PREVIEW / etf_30min / 2010-06-18

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-06-18.parquet
  size:    237 KB
  rows:    8,047

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
2010-06-18 04:00:00	SPY	ETF	111.72	111.72	111.69	111.69	300.0
2010-06-18 04:30:00	SPY	ETF	111.66	111.66	111.66	111.66	200.0
2010-06-18 05:00:00	SPY	ETF	111.69	111.82	111.69	111.76	5500.0
2010-06-18 05:30:00	SPY	ETF	111.74	111.77	111.65	111.65	22100.0
2010-06-18 06:00:00	SPY	ETF	111.67	111.67	111.43	111.49	42190.0
2010-06-18 06:30:00	SPY	ETF	111.49	111.53	111.32	111.45	42052.0
2010-06-18 07:00:00	SPY	ETF	111.41	111.62	111.41	111.59	156070.0
2010-06-18 07:30:00	SPY	ETF	111.62	111.64	111.53	111.53	74735.0
2010-06-18 08:00:00	SPY	ETF	111.54	111.75	111.42	111.43	1547388.0
2010-06-18 08:30:00	SPY	ETF	111.42	111.66	111.41	111.5	923778.0
2010-06-18 09:00:00	SPY	ETF	111.5	111.85	111.38	111.83	3450500.0
2010-06-18 09:30:00	SPY	ETF	111.83	111.84	111.37	111.39	25745082.0
2010-06-18 10:00:00	SPY	ETF	111.4	111.92	111.381	111.869	16240811.0
2010-06-18 10:30:00	SPY	ETF	111.87	112.13	111.5	112.05	14756659.0
2010-06-18 11:00:00	SPY	ETF	112.05	112.13	111.77	111.81	8655825.0
2010-06-18 11:30:00	SPY	ETF	111.82	111.95	111.64	111.74	8058602.0
2010-06-18 12:00:00	SPY	ETF	111.75	112.08	111.52	111.57	8199122.0
2010-06-18 12:30:00	SPY	ETF	111.56	111.8	111.47	111.6	7610841.0
2010-06-18 13:00:00	SPY	ETF	111.6	111.76	111.52	111.67	6058968.0
2010-06-18 13:30:00	SPY	ETF	111.67	111.82	111.51	111.65	10192435.0
2010-06-18 14:00:00	SPY	ETF	111.66	111.88	111.61	111.8602	8494723.0
2010-06-18 14:30:00	SPY	ETF	111.87	111.87	111.69	111.76	6515961.0
2010-06-18 15:00:00	SPY	ETF	111.77	111.775	111.48	111.65	10154789.0
2010-06-18 15:30:00	SPY	ETF	111.65	111.79	111.55	111.71	18739084.0
2010-06-18 16:00:00	SPY	ETF	111.71	112.11	111.44	111.55	11022731.0
2010-06-18 16:30:00	SPY	ETF	111.52	111.665	111.49	111.5	390498.0
2010-06-18 17:00:00	SPY	ETF	111.5	111.729	111.36	111.44	287957.0
2010-06-18 17:30:00	SPY	ETF	111.44	111.53	111.4	111.53	89941.0
2010-06-18 18:00:00	SPY	ETF	111.52	111.66	111.49	111.58	120511.0
2010-06-18 18:30:00	SPY	ETF	111.58	111.64	111.58	111.64	38204.0
2010-06-18 19:00:00	SPY	ETF	111.63	111.63	111.59	111.59	8952.0
2010-06-18 19:30:00	SPY	ETF	111.62	111.7	111.6	111.7	17112.0
2010-06-18 05:30:00	QQQ	ETF	47.08	47.08	47.08	47.08	8315.0
2010-06-18 06:00:00	QQQ	ETF	47.08	47.08	47.08	47.08	4666.0
2010-06-18 07:00:00	QQQ	ETF	47.04	47.04	47.0	47.0	2028.0
2010-06-18 07:30:00	QQQ	ETF	46.99	47.04	46.9	46.91	137058.0
2010-06-18 08:00:00	QQQ	ETF	47.0	47.02	46.84	46.84	1534996.0
2010-06-18 08:30:00	QQQ	ETF	46.85	46.95	46.84	46.91	725865.0
2010-06-18 09:00:00	QQQ	ETF	46.93	47.08	46.9	47.07	1688857.0
2010-06-18 09:30:00	QQQ	ETF	47.07	47.0825	46.89	46.9	11023912.0
2010-06-18 10:00:00	QQQ	ETF	46.91	47.15	46.91	47.1399	7214892.0
2010-06-18 10:30:00	QQQ	ETF	47.135	47.33	47.1201	47.31	7658114.0
2010-06-18 11:00:00	QQQ	ETF	47.3065	47.34	47.14	47.15	3337256.0
2010-06-18 11:30:00	QQQ	ETF	47.14	47.17	47.02	47.09	4168969.0
2010-06-18 12:00:00	QQQ	ETF	47.09	47.16	46.89	46.9125	6248537.0
2010-06-18 12:30:00	QQQ	ETF	46.92	47.02	46.86	46.95	3708105.0
2010-06-18 13:00:00	QQQ	ETF	46.94	47.04	46.9222	46.98	3801660.0
2010-06-18 13:30:00	QQQ	ETF	46.985	47.07	46.92	46.975	2409507.0
2010-06-18 14:00:00	QQQ	ETF	46.975	47.09	46.96	47.0875	3814433.0
2010-06-18 14:30:00	QQQ	ETF	47.0885	47.09	47.0	47.04	3572942.0

> showing 50 of 8,047 rows — these rows as CSV

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