PREVIEW / etf_30min / 2008-09-25

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-09-25.parquet
  size:    175 KB
  rows:    6,185

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-25 04:30:00	SPY	ETF	118.95	119.24	118.95	119.24	200.0
2008-09-25 05:00:00	SPY	ETF	119.71	119.71	119.71	119.71	100.0
2008-09-25 05:30:00	SPY	ETF	119.77	119.77	119.65	119.65	3500.0
2008-09-25 06:00:00	SPY	ETF	119.76	119.78	119.75	119.77	11500.0
2008-09-25 06:30:00	SPY	ETF	119.74	119.74	119.11	119.11	184690.0
2008-09-25 07:00:00	SPY	ETF	119.14	119.23	118.86	119.02	330951.0
2008-09-25 07:30:00	SPY	ETF	119.0	119.22	118.6	119.2	1109480.0
2008-09-25 08:00:00	SPY	ETF	119.17	120.37	118.84	119.95	7090919.0
2008-09-25 08:30:00	SPY	ETF	119.89	120.22	119.54	119.59	5215953.0
2008-09-25 09:00:00	SPY	ETF	119.59	119.85	119.18	119.56	2769068.0
2008-09-25 09:30:00	SPY	ETF	119.56	120.52	119.07	120.35	30214331.0
2008-09-25 10:00:00	SPY	ETF	120.38	121.17	119.96	120.75	34218822.0
2008-09-25 10:30:00	SPY	ETF	120.75	120.89	120.0	120.36	17524750.0
2008-09-25 11:00:00	SPY	ETF	120.36	121.21	120.26	121.08	17413397.0
2008-09-25 11:30:00	SPY	ETF	121.0701	121.25	120.67	120.74	16184395.0
2008-09-25 12:00:00	SPY	ETF	120.74	121.3	120.68	121.18	10320970.0
2008-09-25 12:30:00	SPY	ETF	121.16	121.62	121.08	121.38	15099317.0
2008-09-25 13:00:00	SPY	ETF	121.38	121.87	121.14	121.39	17225902.0
2008-09-25 13:30:00	SPY	ETF	121.4	121.91	121.1	121.529	20913090.0
2008-09-25 14:00:00	SPY	ETF	121.53	121.6	118.4369	120.86	28154054.0
2008-09-25 14:30:00	SPY	ETF	120.8607	121.14	120.43	121.09	19092977.0
2008-09-25 15:00:00	SPY	ETF	121.09	121.71	120.99	121.52	17783223.0
2008-09-25 15:30:00	SPY	ETF	121.52	121.7	120.23	121.01	31318186.0
2008-09-25 16:00:00	SPY	ETF	121.01	121.06	118.4369	120.58	14278335.0
2008-09-25 16:30:00	SPY	ETF	120.58	121.27	118.4369	120.47	16549999.0
2008-09-25 17:00:00	SPY	ETF	120.47	120.87	120.09	120.8	2110920.0
2008-09-25 17:30:00	SPY	ETF	120.79	120.8	120.18	120.42	60731.0
2008-09-25 18:00:00	SPY	ETF	120.5	120.57	120.17	120.35	1137323.0
2008-09-25 18:30:00	SPY	ETF	120.35	120.81	120.31	120.45	145702.0
2008-09-25 19:00:00	SPY	ETF	120.36	120.52	119.85	119.85	219910.0
2008-09-25 19:30:00	SPY	ETF	119.85	120.06	119.55	119.67	144877.0
2008-09-25 04:30:00	QQQ	ETF	41.2	41.28	41.2	41.28	1500.0
2008-09-25 05:00:00	QQQ	ETF	41.43	41.44	41.43	41.44	600.0
2008-09-25 05:30:00	QQQ	ETF	41.5	41.5	41.45	41.45	1400.0
2008-09-25 06:00:00	QQQ	ETF	41.45	41.5	41.45	41.5	80000.0
2008-09-25 06:30:00	QQQ	ETF	41.21	41.24	41.18	41.24	800.0
2008-09-25 07:00:00	QQQ	ETF	41.25	41.25	41.17	41.25	50300.0
2008-09-25 07:30:00	QQQ	ETF	41.19	41.2	40.98	41.15	468721.0
2008-09-25 08:00:00	QQQ	ETF	41.14	41.51	41.12	41.4	3008421.0
2008-09-25 08:30:00	QQQ	ETF	41.4	41.52	41.3	41.32	1192413.0
2008-09-25 09:00:00	QQQ	ETF	41.32	41.39	41.16	41.22	1045939.0
2008-09-25 09:30:00	QQQ	ETF	41.22	41.45	41.03	41.31	15182416.0
2008-09-25 10:00:00	QQQ	ETF	41.31	41.82	41.29	41.65	13605161.0
2008-09-25 10:30:00	QQQ	ETF	41.66	41.7	41.41	41.48	8246457.0
2008-09-25 11:00:00	QQQ	ETF	41.49	41.65	41.43	41.61	7267119.0
2008-09-25 11:30:00	QQQ	ETF	41.62	41.72	41.54	41.55	6501186.0
2008-09-25 12:00:00	QQQ	ETF	41.56	41.69	41.49	41.66	4042784.0
2008-09-25 12:30:00	QQQ	ETF	41.656	41.82	41.63	41.77	5335981.0
2008-09-25 13:00:00	QQQ	ETF	41.77	41.93	41.67	41.8	7542609.0
2008-09-25 13:30:00	QQQ	ETF	41.8	42.02	41.73	41.852	8270643.0

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

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