PREVIEW / etf_30min / 2009-02-02

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-02-02.parquet
  size:    197 KB
  rows:    6,573

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-02-02 04:00:00	SPY	ETF	81.54	81.57	81.42	81.49	1939.0
2009-02-02 04:30:00	SPY	ETF	81.45	81.45	81.17	81.24	1200.0
2009-02-02 05:00:00	SPY	ETF	81.46	81.51	81.42	81.42	800.0
2009-02-02 05:30:00	SPY	ETF	81.37	81.37	81.14	81.14	1118.0
2009-02-02 06:00:00	SPY	ETF	81.24	81.45	81.24	81.45	1388.0
2009-02-02 06:30:00	SPY	ETF	81.47	81.7	81.37	81.68	13700.0
2009-02-02 07:00:00	SPY	ETF	81.69	81.81	81.55	81.55	408002.0
2009-02-02 07:30:00	SPY	ETF	81.56	81.63	81.28	81.46	286886.0
2009-02-02 08:00:00	SPY	ETF	81.43	81.86	81.29	81.31	1165348.0
2009-02-02 08:30:00	SPY	ETF	81.31	83.0	81.15	81.31	1799451.0
2009-02-02 09:00:00	SPY	ETF	81.31	82.9	81.18	81.56	2132825.0
2009-02-02 09:30:00	SPY	ETF	81.57	81.78	81.31	81.67	26301453.0
2009-02-02 10:00:00	SPY	ETF	81.67	82.6	81.63	82.36	38436952.0
2009-02-02 10:30:00	SPY	ETF	82.36	82.51	82.0	82.19	18086994.0
2009-02-02 11:00:00	SPY	ETF	82.19	82.19	81.83	82.09	13721551.0
2009-02-02 11:30:00	SPY	ETF	82.08	82.47	82.01	82.31	16695723.0
2009-02-02 12:00:00	SPY	ETF	82.33	82.71	82.32	82.6	16142927.0
2009-02-02 12:30:00	SPY	ETF	82.61	83.14	82.6	82.97	16094893.0
2009-02-02 13:00:00	SPY	ETF	82.97	83.03	82.25	82.35	13831399.0
2009-02-02 13:30:00	SPY	ETF	82.36	82.58	81.94	82.01	15229809.0
2009-02-02 14:00:00	SPY	ETF	82.02	82.2	81.78	81.93	13287076.0
2009-02-02 14:30:00	SPY	ETF	81.93	82.09	81.71	81.81	16762526.0
2009-02-02 15:00:00	SPY	ETF	81.81	82.5399	81.71	82.53	21792531.0
2009-02-02 15:30:00	SPY	ETF	82.52	83.18	82.52	82.59	35648178.0
2009-02-02 16:00:00	SPY	ETF	82.56	82.6747	82.44	82.57	14422702.0
2009-02-02 16:30:00	SPY	ETF	82.59	82.62	82.53	82.55	1174862.0
2009-02-02 17:00:00	SPY	ETF	82.54	82.6	82.52	82.57	138468.0
2009-02-02 17:30:00	SPY	ETF	82.56	82.56	82.51	82.54	20425.0
2009-02-02 18:00:00	SPY	ETF	82.53	82.55	82.36	82.38	282281.0
2009-02-02 18:30:00	SPY	ETF	82.36	82.53	82.29	82.52	128292.0
2009-02-02 19:00:00	SPY	ETF	82.54	82.73	82.53	82.7	54665.0
2009-02-02 19:30:00	SPY	ETF	82.69	82.76	82.66	82.76	20614.0
2009-02-02 04:00:00	QQQ	ETF	28.63	28.63	28.63	28.63	3149.0
2009-02-02 04:30:00	QQQ	ETF	28.53	28.53	28.48	28.5	2197.0
2009-02-02 05:00:00	QQQ	ETF	28.6	28.6	28.6	28.6	1722.0
2009-02-02 05:30:00	QQQ	ETF	28.45	28.45	28.45	28.45	100.0
2009-02-02 06:00:00	QQQ	ETF	28.53	28.55	28.53	28.55	11000.0
2009-02-02 06:30:00	QQQ	ETF	28.5	28.5	28.5	28.5	5000.0
2009-02-02 07:00:00	QQQ	ETF	28.6	28.65	28.56	28.62	179796.0
2009-02-02 07:30:00	QQQ	ETF	28.63	28.65	28.51	28.58	165956.0
2009-02-02 08:00:00	QQQ	ETF	28.58	28.73	28.58	28.63	825811.0
2009-02-02 08:30:00	QQQ	ETF	28.63	28.72	28.58	28.62	414415.0
2009-02-02 09:00:00	QQQ	ETF	28.63	28.79	28.62	28.77	467481.0
2009-02-02 09:30:00	QQQ	ETF	28.77	29.01	28.74	28.9501	15004596.0
2009-02-02 10:00:00	QQQ	ETF	28.95	29.43	28.95	29.32	16781905.0
2009-02-02 10:30:00	QQQ	ETF	29.32	29.34	29.16	29.22	8817439.0
2009-02-02 11:00:00	QQQ	ETF	29.21	29.24	29.13	29.212	5427371.0
2009-02-02 11:30:00	QQQ	ETF	29.21	29.32	29.15	29.25	6306809.0
2009-02-02 12:00:00	QQQ	ETF	29.25	29.39	29.25	29.3499	8336471.0
2009-02-02 12:30:00	QQQ	ETF	29.35	29.5	29.34	29.4497	8266053.0

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

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