PREVIEW / etf_30min / 2008-09-23

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-09-23.parquet
  size:    180 KB
  rows:    6,273

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-23 04:00:00	SPY	ETF	121.49	121.49	121.49	121.49	100.0
2008-09-23 04:30:00	SPY	ETF	121.36	121.41	121.01	121.01	1200.0
2008-09-23 05:00:00	SPY	ETF	121.01	121.01	121.0	121.0	1700.0
2008-09-23 05:30:00	SPY	ETF	120.87	120.87	120.87	120.87	100.0
2008-09-23 06:00:00	SPY	ETF	121.07	121.21	121.05	121.17	97600.0
2008-09-23 06:30:00	SPY	ETF	121.17	121.17	120.76	120.82	149214.0
2008-09-23 07:00:00	SPY	ETF	120.86	121.15	120.67	120.95	297965.0
2008-09-23 07:30:00	SPY	ETF	121.01	121.26	120.62	120.75	645334.0
2008-09-23 08:00:00	SPY	ETF	120.76	121.36	120.48	120.67	1463279.0
2008-09-23 08:30:00	SPY	ETF	120.68	121.18	120.62	120.89	986847.0
2008-09-23 09:00:00	SPY	ETF	120.9	121.13	120.76	120.86	1679279.0
2008-09-23 09:30:00	SPY	ETF	120.85	122.02	120.52	121.31	27272053.0
2008-09-23 10:00:00	SPY	ETF	121.32	121.99	121.16	121.66	18796159.0
2008-09-23 10:30:00	SPY	ETF	121.66	122.0	120.56	120.82	19293187.0
2008-09-23 11:00:00	SPY	ETF	120.82	121.39	120.43	121.05	19213031.0
2008-09-23 11:30:00	SPY	ETF	121.06	121.28	120.67	120.72	11294854.0
2008-09-23 12:00:00	SPY	ETF	120.73	121.06	120.35	120.53	11813420.0
2008-09-23 12:30:00	SPY	ETF	120.53	120.61	119.85	119.88	14866893.0
2008-09-23 13:00:00	SPY	ETF	119.89	119.93	118.82	119.11	25690994.0
2008-09-23 13:30:00	SPY	ETF	119.11	119.14	118.5	119.02	27937081.0
2008-09-23 14:00:00	SPY	ETF	119.025	120.5541	118.28	120.07	36327916.0
2008-09-23 14:30:00	SPY	ETF	120.0601	120.75	119.643	120.23	26362400.0
2008-09-23 15:00:00	SPY	ETF	120.23	121.19	120.16	120.34	22578190.0
2008-09-23 15:30:00	SPY	ETF	120.34	120.52	118.55	118.72	35256591.0
2008-09-23 16:00:00	SPY	ETF	118.7	121.31	118.39	118.65	10885675.0
2008-09-23 16:30:00	SPY	ETF	118.63	121.0542	118.55	118.8	8986468.0
2008-09-23 17:00:00	SPY	ETF	118.82	118.85	118.55	118.81	130907.0
2008-09-23 17:30:00	SPY	ETF	118.88	120.5	118.6	120.44	678530.0
2008-09-23 18:00:00	SPY	ETF	120.42	120.8	120.2	120.4	945043.0
2008-09-23 18:30:00	SPY	ETF	120.43	120.52	120.07	120.14	179649.0
2008-09-23 19:00:00	SPY	ETF	120.13	120.35	120.01	120.07	108662.0
2008-09-23 19:30:00	SPY	ETF	120.1	120.15	119.5	120.01	139503.0
2008-09-23 04:30:00	QQQ	ETF	41.09	41.1	41.09	41.1	1800.0
2008-09-23 05:30:00	QQQ	ETF	40.97	40.97	40.97	40.97	100.0
2008-09-23 06:30:00	QQQ	ETF	40.96	40.96	40.89	40.93	400.0
2008-09-23 07:00:00	QQQ	ETF	40.94	40.99	40.88	40.93	42000.0
2008-09-23 07:30:00	QQQ	ETF	40.99	41.09	40.9	40.95	124942.0
2008-09-23 08:00:00	QQQ	ETF	40.95	40.99	40.86	40.91	500591.0
2008-09-23 08:30:00	QQQ	ETF	40.91	41.24	40.91	41.24	731986.0
2008-09-23 09:00:00	QQQ	ETF	41.23	41.34	41.17	41.18	1955119.0
2008-09-23 09:30:00	QQQ	ETF	41.18	41.52	41.11	41.38	21809171.0
2008-09-23 10:00:00	QQQ	ETF	41.38	41.74	41.3	41.65	14427320.0
2008-09-23 10:30:00	QQQ	ETF	41.6505	41.75	41.26	41.3717	11883424.0
2008-09-23 11:00:00	QQQ	ETF	41.37	41.62	41.25	41.49	7964351.0
2008-09-23 11:30:00	QQQ	ETF	41.49	41.55	41.34	41.3401	3785949.0
2008-09-23 12:00:00	QQQ	ETF	41.34	41.39	41.18	41.19	4169577.0
2008-09-23 12:30:00	QQQ	ETF	41.19	41.23	40.93	40.9883	5602888.0
2008-09-23 13:00:00	QQQ	ETF	40.9889	40.99	40.6	40.77	9421691.0
2008-09-23 13:30:00	QQQ	ETF	40.76	40.765	40.44	40.66	9458915.0
2008-09-23 14:00:00	QQQ	ETF	40.6695	41.12	40.56	41.1095	11370167.0

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

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