PREVIEW / etf_1hour / 2010-06-07

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-06-07.parquet
  size:    167 KB
  rows:    5,059

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-07 04:00:00	SPY	ETF	106.57	106.83	106.57	106.81	3474.0
2010-06-07 05:00:00	SPY	ETF	106.65	107.0	106.65	107.0	14172.0
2010-06-07 06:00:00	SPY	ETF	107.12	107.35	106.99	107.25	45182.0
2010-06-07 07:00:00	SPY	ETF	107.26	107.5	107.2	107.26	1030260.0
2010-06-07 08:00:00	SPY	ETF	107.26	107.59	106.2375	107.3	4429124.0
2010-06-07 09:00:00	SPY	ETF	107.3	107.43	106.57	107.27	36274655.0
2010-06-07 10:00:00	SPY	ETF	107.27	107.61	106.35	106.42	41084442.0
2010-06-07 11:00:00	SPY	ETF	106.42	107.03	106.28	107.0	29805548.0
2010-06-07 12:00:00	SPY	ETF	107.0	107.28	106.89	107.13	19387412.0
2010-06-07 13:00:00	SPY	ETF	107.12	107.37	106.67	106.82	16201064.0
2010-06-07 14:00:00	SPY	ETF	106.815	106.95	106.13	106.32	23520517.0
2010-06-07 15:00:00	SPY	ETF	106.32	106.69	105.41	105.5	66798675.0
2010-06-07 16:00:00	SPY	ETF	105.49	107.58	105.22	105.48	14574489.0
2010-06-07 17:00:00	SPY	ETF	105.48	106.9384	105.4	105.44	1286262.0
2010-06-07 18:00:00	SPY	ETF	105.44	105.49	105.29	105.45	92479.0
2010-06-07 19:00:00	SPY	ETF	105.45	105.73	105.45	105.7	217309.0
2010-06-07 04:00:00	QQQ	ETF	44.92	45.1	44.92	45.1	5700.0
2010-06-07 05:00:00	QQQ	ETF	45.09	45.23	45.09	45.23	3000.0
2010-06-07 06:00:00	QQQ	ETF	45.27	45.28	45.26	45.27	2800.0
2010-06-07 07:00:00	QQQ	ETF	45.26	45.36	45.26	45.27	704058.0
2010-06-07 08:00:00	QQQ	ETF	45.28	45.45	45.23	45.33	2712270.0
2010-06-07 09:00:00	QQQ	ETF	45.34	45.42	44.99	45.34	14714740.0
2010-06-07 10:00:00	QQQ	ETF	45.34	45.46	44.67	44.7	14020782.0
2010-06-07 11:00:00	QQQ	ETF	44.71	44.95	44.6199	44.95	8110022.0
2010-06-07 12:00:00	QQQ	ETF	44.94	45.08	44.87	45.0399	3720109.0
2010-06-07 13:00:00	QQQ	ETF	45.04	45.17	44.79	44.86	6495079.0
2010-06-07 14:00:00	QQQ	ETF	44.85	44.9226	44.46	44.5501	10882182.0
2010-06-07 15:00:00	QQQ	ETF	44.56	44.705	44.22	44.28	20597694.0
2010-06-07 16:00:00	QQQ	ETF	44.28	45.2386	44.2	44.24	5143880.0
2010-06-07 17:00:00	QQQ	ETF	44.25	44.27	44.21	44.23	23944.0
2010-06-07 18:00:00	QQQ	ETF	44.25	44.27	44.2	44.27	26849.0
2010-06-07 19:00:00	QQQ	ETF	44.27	44.42	44.27	44.4	243581.0
2010-06-07 06:00:00	IWM	ETF	64.01	64.07	64.01	64.06	2800.0
2010-06-07 07:00:00	IWM	ETF	64.03	64.12	63.95	63.95	98158.0
2010-06-07 08:00:00	IWM	ETF	63.97	64.22	62.65	63.98	609655.0
2010-06-07 09:00:00	IWM	ETF	64.01	64.07	62.91	63.73	9920239.0
2010-06-07 10:00:00	IWM	ETF	63.73	64.11	62.78	62.83	12256881.0
2010-06-07 11:00:00	IWM	ETF	62.8301	63.23	62.65	63.22	10417939.0
2010-06-07 12:00:00	IWM	ETF	63.21	63.489	63.09	63.33	5447276.0
2010-06-07 13:00:00	IWM	ETF	63.33	63.642	63.06	63.13	4570428.0
2010-06-07 14:00:00	IWM	ETF	63.12	63.22	62.41	62.51	9439768.0
2010-06-07 15:00:00	IWM	ETF	62.5	62.9	61.86	61.94	20323439.0
2010-06-07 16:00:00	IWM	ETF	61.94	63.65	61.82	61.9	12459338.0
2010-06-07 17:00:00	IWM	ETF	61.93	61.93	61.87	61.9	11417.0
2010-06-07 18:00:00	IWM	ETF	61.92	61.93	61.88	61.88	1802.0
2010-06-07 19:00:00	IWM	ETF	61.89	62.16	61.89	62.16	10700.0
2010-06-07 05:00:00	DIA	ETF	99.85	100.14	99.85	99.98	3500.0
2010-06-07 06:00:00	DIA	ETF	99.61	99.63	99.61	99.63	3500.0
2010-06-07 07:00:00	DIA	ETF	99.7	99.77	99.63	99.65	1609.0
2010-06-07 08:00:00	DIA	ETF	99.66	99.93	99.61	99.75	43580.0

> showing 50 of 5,059 rows — these rows as CSV

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