PREVIEW / etf_30min / 2009-08-14

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-08-14.parquet
  size:    223 KB
  rows:    7,371

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2009-08-14 04:00:00	SPY	ETF	101.9	101.94	101.84	101.85	5500.0
2009-08-14 05:00:00	SPY	ETF	101.78	101.78	101.78	101.78	2000.0
2009-08-14 05:30:00	SPY	ETF	101.74	101.74	101.6	101.6	4100.0
2009-08-14 06:00:00	SPY	ETF	101.71	101.71	101.67	101.67	8000.0
2009-08-14 06:30:00	SPY	ETF	101.65	101.7	101.62	101.64	156043.0
2009-08-14 07:00:00	SPY	ETF	101.62	101.82	101.62	101.78	86302.0
2009-08-14 07:30:00	SPY	ETF	101.82	101.89	101.75	101.78	297862.0
2009-08-14 08:00:00	SPY	ETF	101.77	101.89	101.77	101.84	636838.0
2009-08-14 08:30:00	SPY	ETF	101.85	101.88	101.49	101.56	4226186.0
2009-08-14 09:00:00	SPY	ETF	101.55	101.76	101.41	101.53	2095920.0
2009-08-14 09:30:00	SPY	ETF	101.52	101.6	100.5	100.6	28776739.0
2009-08-14 10:00:00	SPY	ETF	100.61	101.52	99.87	100.09	28957859.0
2009-08-14 10:30:00	SPY	ETF	100.1	100.18	99.86	100.11	16435719.0
2009-08-14 11:00:00	SPY	ETF	100.1	100.2	99.85	99.86	12022521.0
2009-08-14 11:30:00	SPY	ETF	99.85	101.6	99.7	99.9	11494731.0
2009-08-14 12:00:00	SPY	ETF	99.89	100.0	99.83	99.87	6618291.0
2009-08-14 12:30:00	SPY	ETF	99.86	100.12	99.8	100.11	6834864.0
2009-08-14 13:00:00	SPY	ETF	100.11	100.14	99.92	100.02	6613112.0
2009-08-14 13:30:00	SPY	ETF	100.01	100.04	99.86	100.03	5565702.0
2009-08-14 14:00:00	SPY	ETF	100.04	100.09	99.9	99.96	6913495.0
2009-08-14 14:30:00	SPY	ETF	99.97	100.21	99.93	100.12	8156801.0
2009-08-14 15:00:00	SPY	ETF	100.12	100.27	99.97	100.0	11674839.0
2009-08-14 15:30:00	SPY	ETF	100.0	100.74	99.99	100.73	24876340.0
2009-08-14 16:00:00	SPY	ETF	100.74	101.13	99.9	100.96	15957650.0
2009-08-14 16:30:00	SPY	ETF	100.97	101.01	100.93	100.97	487452.0
2009-08-14 17:00:00	SPY	ETF	100.97	100.99	100.87	100.9	239020.0
2009-08-14 17:30:00	SPY	ETF	100.9	100.94	100.88	100.9	51000.0
2009-08-14 18:00:00	SPY	ETF	100.9	100.94	100.88	100.9	18408.0
2009-08-14 18:30:00	SPY	ETF	100.93	100.94	100.87	100.89	16965.0
2009-08-14 19:00:00	SPY	ETF	100.93	100.94	100.88	100.9	5850.0
2009-08-14 19:30:00	SPY	ETF	100.9	100.98	100.9	100.93	40811.0
2009-08-14 04:00:00	QQQ	ETF	40.15	40.15	40.15	40.15	1300.0
2009-08-14 06:00:00	QQQ	ETF	40.09	40.09	40.09	40.09	200.0
2009-08-14 06:30:00	QQQ	ETF	40.07	40.07	40.07	40.07	300.0
2009-08-14 07:00:00	QQQ	ETF	40.06	40.06	40.06	40.06	1000.0
2009-08-14 07:30:00	QQQ	ETF	40.13	40.17	40.12	40.13	34964.0
2009-08-14 08:00:00	QQQ	ETF	40.13	40.15	40.05	40.05	900302.0
2009-08-14 08:30:00	QQQ	ETF	40.07	40.11	39.84	39.86	7858063.0
2009-08-14 09:00:00	QQQ	ETF	39.87	39.97	39.85	39.89	1915245.0
2009-08-14 09:30:00	QQQ	ETF	39.89	39.96	39.5	39.58	19693033.0
2009-08-14 10:00:00	QQQ	ETF	39.59	39.59	39.35	39.44	14695564.0
2009-08-14 10:30:00	QQQ	ETF	39.44	39.49	39.36	39.44	8554320.0
2009-08-14 11:00:00	QQQ	ETF	39.44	39.5	39.34	39.34	6568210.0
2009-08-14 11:30:00	QQQ	ETF	39.34	39.37	39.28	39.315	3847065.0
2009-08-14 12:00:00	QQQ	ETF	39.3199	39.39	39.3	39.33	3373689.0
2009-08-14 12:30:00	QQQ	ETF	39.32	39.43	39.3	39.42	2456922.0
2009-08-14 13:00:00	QQQ	ETF	39.4101	39.45	39.36	39.39	3161713.0
2009-08-14 13:30:00	QQQ	ETF	39.4	39.44	39.34	39.44	4212171.0
2009-08-14 14:00:00	QQQ	ETF	39.44	39.45	39.36	39.4	5937240.0
2009-08-14 14:30:00	QQQ	ETF	39.4	39.48	39.38	39.42	4113172.0

> showing 50 of 7,371 rows — these rows as CSV

> unlock the full archive -- $79 one-time