PREVIEW / etf_1hour / 2010-03-10

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-03-10.parquet
  size:    154 KB
  rows:    4,790

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-03-10 04:00:00	SPY	ETF	114.55	114.62	114.46	114.5	23300.0
2010-03-10 05:00:00	SPY	ETF	114.44	114.54	114.44	114.46	6100.0
2010-03-10 06:00:00	SPY	ETF	114.6	114.65	114.6	114.61	1200.0
2010-03-10 07:00:00	SPY	ETF	114.63	114.69	114.46	114.53	234785.0
2010-03-10 08:00:00	SPY	ETF	114.52	114.65	114.35	114.55	1395502.0
2010-03-10 09:00:00	SPY	ETF	114.55	114.85	114.41	114.76	17980570.0
2010-03-10 10:00:00	SPY	ETF	114.76	115.21	114.75	115.11	24659719.0
2010-03-10 11:00:00	SPY	ETF	115.1	115.275	114.92	115.03	22596774.0
2010-03-10 12:00:00	SPY	ETF	115.03	115.1362	114.41	114.83	27329675.0
2010-03-10 13:00:00	SPY	ETF	114.8318	115.0	114.71	114.78	15504949.0
2010-03-10 14:00:00	SPY	ETF	114.775	115.22	114.71	114.98	20691178.0
2010-03-10 15:00:00	SPY	ETF	114.98	115.17	114.4748	114.98	36863325.0
2010-03-10 16:00:00	SPY	ETF	114.97	115.2	114.4748	115.03	14703553.0
2010-03-10 17:00:00	SPY	ETF	115.04	115.04	114.4748	115.02	2353173.0
2010-03-10 18:00:00	SPY	ETF	114.99	115.01	114.9	114.95	128345.0
2010-03-10 19:00:00	SPY	ETF	114.94	115.02	114.89	114.91	106688.0
2010-03-10 05:00:00	QQQ	ETF	46.86	46.86	46.86	46.86	10000.0
2010-03-10 07:00:00	QQQ	ETF	46.89	46.9	46.82	46.86	10213.0
2010-03-10 08:00:00	QQQ	ETF	46.85	46.9	46.82	46.86	399942.0
2010-03-10 09:00:00	QQQ	ETF	46.85	46.98	46.8	46.968	12447941.0
2010-03-10 10:00:00	QQQ	ETF	46.96	47.19	46.96	47.16	15960443.0
2010-03-10 11:00:00	QQQ	ETF	47.15	47.24	46.9875	47.185	14150370.0
2010-03-10 12:00:00	QQQ	ETF	47.185	47.2	46.9875	47.16	14023706.0
2010-03-10 13:00:00	QQQ	ETF	47.15	47.225	47.1	47.121	8259947.0
2010-03-10 14:00:00	QQQ	ETF	47.1225	47.28	47.09	47.2	7893513.0
2010-03-10 15:00:00	QQQ	ETF	47.2	47.27	47.09	47.17	14037960.0
2010-03-10 16:00:00	QQQ	ETF	47.17	47.22	46.8014	47.2	11709861.0
2010-03-10 17:00:00	QQQ	ETF	47.18	47.2	47.15	47.2	24367.0
2010-03-10 18:00:00	QQQ	ETF	47.19	47.19	47.15	47.15	13000.0
2010-03-10 19:00:00	QQQ	ETF	47.15	47.17	47.12	47.14	8675.0
2010-03-10 06:00:00	IWM	ETF	67.07	67.09	67.07	67.09	2100.0
2010-03-10 07:00:00	IWM	ETF	67.07	67.08	66.98	67.01	11414.0
2010-03-10 08:00:00	IWM	ETF	67.0	67.08	66.98	67.02	361244.0
2010-03-10 09:00:00	IWM	ETF	67.01	67.32	66.98	67.15	7945439.0
2010-03-10 10:00:00	IWM	ETF	67.15	67.81	67.15	67.74	9671757.0
2010-03-10 11:00:00	IWM	ETF	67.735	67.9	67.49	67.67	11592813.0
2010-03-10 12:00:00	IWM	ETF	67.67	67.71	67.12	67.42	14178089.0
2010-03-10 13:00:00	IWM	ETF	67.42	67.5	67.25	67.32	8861498.0
2010-03-10 14:00:00	IWM	ETF	67.32	67.61	67.28	67.46	5913303.0
2010-03-10 15:00:00	IWM	ETF	67.46	67.57	67.291	67.55	10429789.0
2010-03-10 16:00:00	IWM	ETF	67.54	67.71	67.039	67.57	4118447.0
2010-03-10 17:00:00	IWM	ETF	67.485	67.6	67.485	67.58	32427.0
2010-03-10 18:00:00	IWM	ETF	67.57	67.6	67.52	67.52	4210.0
2010-03-10 19:00:00	IWM	ETF	67.57	67.6	67.45	67.58	9386.0
2010-03-10 07:00:00	DIA	ETF	105.8	105.8	105.8	105.8	100.0
2010-03-10 08:00:00	DIA	ETF	105.85	105.87	105.77	105.79	3915.0
2010-03-10 09:00:00	DIA	ETF	105.83	106.04	105.75	105.86	820633.0
2010-03-10 10:00:00	DIA	ETF	105.85	106.14	105.85	105.995	1122532.0
2010-03-10 11:00:00	DIA	ETF	105.982	106.11	105.79	105.92	1243345.0
2010-03-10 12:00:00	DIA	ETF	105.9	105.93	105.38	105.7	1379846.0

> showing 50 of 4,790 rows — these rows as CSV

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