PREVIEW / etf_30min / 2009-08-21

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-08-21.parquet
  size:    232 KB
  rows:    7,674

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-21 04:00:00	SPY	ETF	100.79	100.79	100.79	100.79	500.0
2009-08-21 04:30:00	SPY	ETF	100.86	101.0	100.86	101.0	1000.0
2009-08-21 05:00:00	SPY	ETF	101.02	101.02	101.02	101.02	5100.0
2009-08-21 05:30:00	SPY	ETF	101.11	101.25	101.11	101.25	800.0
2009-08-21 06:00:00	SPY	ETF	101.29	101.55	101.29	101.54	4950.0
2009-08-21 06:30:00	SPY	ETF	101.41	101.5	101.39	101.46	15806.0
2009-08-21 07:00:00	SPY	ETF	101.46	101.6	101.46	101.6	262273.0
2009-08-21 07:30:00	SPY	ETF	101.54	101.57	101.39	101.45	304376.0
2009-08-21 08:00:00	SPY	ETF	101.46	101.6	100.19	101.59	826637.0
2009-08-21 08:30:00	SPY	ETF	101.59	101.63	101.5	101.63	1053779.0
2009-08-21 09:00:00	SPY	ETF	101.63	101.87	101.61	101.82	2925868.0
2009-08-21 09:30:00	SPY	ETF	101.82	102.4273	101.62	101.99	27786651.0
2009-08-21 10:00:00	SPY	ETF	101.99	102.95	101.99	102.61	41428389.0
2009-08-21 10:30:00	SPY	ETF	102.61	102.82	102.51	102.62	15108922.0
2009-08-21 11:00:00	SPY	ETF	102.62	102.76	102.61	102.7	8899932.0
2009-08-21 11:30:00	SPY	ETF	102.7	102.87	102.67	102.78	8473476.0
2009-08-21 12:00:00	SPY	ETF	102.78	102.79	102.67	102.76	5174490.0
2009-08-21 12:30:00	SPY	ETF	102.75	102.79	102.65	102.7	5843071.0
2009-08-21 13:00:00	SPY	ETF	102.7	102.8	102.66	102.73	6102809.0
2009-08-21 13:30:00	SPY	ETF	102.74	102.77	102.54	102.57	9454239.0
2009-08-21 14:00:00	SPY	ETF	102.56	102.72	102.5	102.6504	6642826.0
2009-08-21 14:30:00	SPY	ETF	102.66	102.735	102.62	102.73	5661456.0
2009-08-21 15:00:00	SPY	ETF	102.73	103.13	102.71	103.04	17105312.0
2009-08-21 15:30:00	SPY	ETF	103.03	103.12	102.65	102.92	31294236.0
2009-08-21 16:00:00	SPY	ETF	102.91	103.04	101.8	102.98	17301818.0
2009-08-21 16:30:00	SPY	ETF	102.98	103.02	101.074	102.96	6287835.0
2009-08-21 17:00:00	SPY	ETF	102.97	102.98	101.074	102.96	1093988.0
2009-08-21 17:30:00	SPY	ETF	102.96	103.02	102.96	103.02	70406.0
2009-08-21 18:00:00	SPY	ETF	103.02	103.02	102.93	103.0	53974.0
2009-08-21 18:30:00	SPY	ETF	102.99	102.99	102.9	102.92	28988.0
2009-08-21 19:00:00	SPY	ETF	102.92	102.94	102.92	102.92	7740.0
2009-08-21 19:30:00	SPY	ETF	102.92	102.95	102.9	102.91	32522.0
2009-08-21 06:00:00	QQQ	ETF	39.92	39.92	39.88	39.89	4456.0
2009-08-21 06:30:00	QQQ	ETF	39.85	39.87	39.85	39.87	400.0
2009-08-21 07:00:00	QQQ	ETF	39.87	39.93	39.87	39.92	51600.0
2009-08-21 07:30:00	QQQ	ETF	39.93	39.93	39.85	39.87	206987.0
2009-08-21 08:00:00	QQQ	ETF	39.87	39.92	39.38	39.92	395083.0
2009-08-21 08:30:00	QQQ	ETF	39.91	39.93	39.87	39.92	172378.0
2009-08-21 09:00:00	QQQ	ETF	39.94	40.02	39.93	40.0	1277346.0
2009-08-21 09:30:00	QQQ	ETF	40.01	40.05	39.74	39.8905	17086210.0
2009-08-21 10:00:00	QQQ	ETF	39.9	40.36	39.9	40.18	21892106.0
2009-08-21 10:30:00	QQQ	ETF	40.1806	40.29	39.8	40.24	4688994.0
2009-08-21 11:00:00	QQQ	ETF	40.24	40.26	39.8	40.232	3466960.0
2009-08-21 11:30:00	QQQ	ETF	40.23	40.2701	40.2	40.22	3929126.0
2009-08-21 12:00:00	QQQ	ETF	40.22	40.24	40.2	40.228	2584973.0
2009-08-21 12:30:00	QQQ	ETF	40.23	40.24	40.17	40.19	2298273.0
2009-08-21 13:00:00	QQQ	ETF	40.18	40.23	40.16	40.1794	2277110.0
2009-08-21 13:30:00	QQQ	ETF	40.1704	40.18	40.06	40.09	5874552.0
2009-08-21 14:00:00	QQQ	ETF	40.09	40.17	40.08	40.15	4106335.0
2009-08-21 14:30:00	QQQ	ETF	40.14	40.22	40.14	40.22	6990237.0

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

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