PREVIEW / etf_30min / 2008-09-22

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-09-22.parquet
  size:    181 KB
  rows:    6,315

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
2008-09-22 05:00:00	SPY	ETF	123.72	123.72	123.72	123.72	2500.0
2008-09-22 06:00:00	SPY	ETF	123.64	123.64	123.45	123.5	35500.0
2008-09-22 06:30:00	SPY	ETF	123.39	123.6	123.35	123.6	14200.0
2008-09-22 07:00:00	SPY	ETF	123.74	123.74	123.48	123.58	151590.0
2008-09-22 07:30:00	SPY	ETF	123.71	123.8	123.5	123.69	217935.0
2008-09-22 08:00:00	SPY	ETF	123.68	124.29	122.4	124.0	1847570.0
2008-09-22 08:30:00	SPY	ETF	124.03	125.0	122.406	124.05	2357145.0
2008-09-22 09:00:00	SPY	ETF	124.05	124.76	123.39	124.45	4819661.0
2008-09-22 09:30:00	SPY	ETF	124.4505	124.75	123.39	123.66	20742549.0
2008-09-22 10:00:00	SPY	ETF	123.66	123.85	122.96	123.4133	18465124.0
2008-09-22 10:30:00	SPY	ETF	123.41	123.83	123.34	123.6	14214657.0
2008-09-22 11:00:00	SPY	ETF	123.6	123.64	122.52	122.72	13524951.0
2008-09-22 11:30:00	SPY	ETF	122.72	122.91	122.33	122.74	13610671.0
2008-09-22 12:00:00	SPY	ETF	122.74	122.86	122.41	122.81	8018155.0
2008-09-22 12:30:00	SPY	ETF	122.8098	123.73	122.77	123.1	8531927.0
2008-09-22 13:00:00	SPY	ETF	123.09	123.19	122.33	122.46	12527927.0
2008-09-22 13:30:00	SPY	ETF	122.46	122.82	121.94	122.69	19039836.0
2008-09-22 14:00:00	SPY	ETF	122.69	122.92	122.12	122.47	16020932.0
2008-09-22 14:30:00	SPY	ETF	122.47	123.05	121.93	122.06	16617834.0
2008-09-22 15:00:00	SPY	ETF	122.06	122.5	121.04	121.11	21235946.0
2008-09-22 15:30:00	SPY	ETF	121.12	121.3	120.36	120.6	36620987.0
2008-09-22 16:00:00	SPY	ETF	120.71	125.3426	120.54	121.1	10446736.0
2008-09-22 16:30:00	SPY	ETF	121.1	121.34	121.05	121.3	149051.0
2008-09-22 17:00:00	SPY	ETF	121.28	124.2	121.28	121.43	1100550.0
2008-09-22 17:30:00	SPY	ETF	121.38	121.38	121.28	121.37	34600.0
2008-09-22 18:00:00	SPY	ETF	121.35	125.3426	121.27	121.33	2540610.0
2008-09-22 18:30:00	SPY	ETF	121.29	121.35	121.29	121.32	11205.0
2008-09-22 19:00:00	SPY	ETF	121.33	121.38	121.3	121.3	9467.0
2008-09-22 19:30:00	SPY	ETF	121.31	121.33	121.16	121.29	5256.0
2008-09-22 05:30:00	QQQ	ETF	42.49	42.49	42.48	42.48	10000.0
2008-09-22 07:00:00	QQQ	ETF	42.5	42.51	42.37	42.45	34000.0
2008-09-22 07:30:00	QQQ	ETF	42.5	42.5	42.4	42.4	60012.0
2008-09-22 08:00:00	QQQ	ETF	42.41	42.53	42.37	42.51	239857.0
2008-09-22 08:30:00	QQQ	ETF	42.53	42.81	42.48	42.81	2353230.0
2008-09-22 09:00:00	QQQ	ETF	42.8	42.95	42.73	42.76	4532607.0
2008-09-22 09:30:00	QQQ	ETF	42.75	42.84	42.364	42.48	21190707.0
2008-09-22 10:00:00	QQQ	ETF	42.48	42.532	42.27	42.41	12073272.0
2008-09-22 10:30:00	QQQ	ETF	42.408	42.58	42.35	42.53	9645269.0
2008-09-22 11:00:00	QQQ	ETF	42.52	42.54	42.0799	42.15	10215362.0
2008-09-22 11:30:00	QQQ	ETF	42.15	42.19	41.9	42.01	8102031.0
2008-09-22 12:00:00	QQQ	ETF	42.02	42.09	41.95	42.02	4726248.0
2008-09-22 12:30:00	QQQ	ETF	42.022	42.15	42.01	42.06	5194783.0
2008-09-22 13:00:00	QQQ	ETF	42.06	42.09	41.8	41.83	8901738.0
2008-09-22 13:30:00	QQQ	ETF	41.8396	41.96	41.66	41.87	11220267.0
2008-09-22 14:00:00	QQQ	ETF	41.87	42.0178	41.67	41.69	9468265.0
2008-09-22 14:30:00	QQQ	ETF	41.7	41.91	41.58	41.62	9221813.0
2008-09-22 15:00:00	QQQ	ETF	41.62	41.7	41.25	41.27	14162012.0
2008-09-22 15:30:00	QQQ	ETF	41.28	41.35	40.9099	40.91	24003495.0
2008-09-22 16:00:00	QQQ	ETF	40.91	41.2577	40.8	40.97	4862330.0
2008-09-22 16:30:00	QQQ	ETF	40.99	41.03	40.94	41.03	179156.0

> showing 50 of 6,315 rows — these rows as CSV

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