PREVIEW / etf_1hour / 2011-01-05

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-01-05.parquet
  size:    179 KB
  rows:    5,490

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
2011-01-05 04:00:00	SPY	ETF	126.64	126.64	126.2	126.25	7804.0
2011-01-05 05:00:00	SPY	ETF	126.24	126.24	126.11	126.11	1200.0
2011-01-05 06:00:00	SPY	ETF	126.1	126.18	125.95	126.09	58050.0
2011-01-05 07:00:00	SPY	ETF	126.06	126.2	126.03	126.13	697580.0
2011-01-05 08:00:00	SPY	ETF	126.16	126.8	126.06	126.59	4210942.0
2011-01-05 09:00:00	SPY	ETF	126.59	126.93	126.45	126.73	18072007.0
2011-01-05 10:00:00	SPY	ETF	126.73	127.08	126.6742	126.96	20833660.0
2011-01-05 11:00:00	SPY	ETF	126.96	127.51	126.89	127.4099	19665475.0
2011-01-05 12:00:00	SPY	ETF	127.4001	127.65	127.375	127.54	12332963.0
2011-01-05 13:00:00	SPY	ETF	127.54	127.645	127.41	127.6	12607037.0
2011-01-05 14:00:00	SPY	ETF	127.61	127.67	127.42	127.58	9652409.0
2011-01-05 15:00:00	SPY	ETF	127.58	127.725	127.5	127.63	21266872.0
2011-01-05 16:00:00	SPY	ETF	127.62	127.72	126.555	127.48	12200215.0
2011-01-05 17:00:00	SPY	ETF	127.48	127.53	127.41	127.48	128164.0
2011-01-05 18:00:00	SPY	ETF	127.48	127.64	127.48	127.55	47392.0
2011-01-05 19:00:00	SPY	ETF	127.57	127.58	127.48	127.48	67454.0
2011-01-05 04:00:00	QQQ	ETF	55.01	55.01	54.85	54.89	4500.0
2011-01-05 05:00:00	QQQ	ETF	54.86	54.86	54.85	54.85	5600.0
2011-01-05 06:00:00	QQQ	ETF	54.85	54.86	54.77	54.8	23300.0
2011-01-05 07:00:00	QQQ	ETF	54.81	54.86	54.8	54.83	136169.0
2011-01-05 08:00:00	QQQ	ETF	54.84	55.11	54.82	55.07	1234357.0
2011-01-05 09:00:00	QQQ	ETF	55.07	55.24	55.06	55.21	5736889.0
2011-01-05 10:00:00	QQQ	ETF	55.22	55.49	55.21	55.45	8584995.0
2011-01-05 11:00:00	QQQ	ETF	55.46	55.69	55.44	55.59	5461836.0
2011-01-05 12:00:00	QQQ	ETF	55.59	55.73	55.57	55.67	4307049.0
2011-01-05 13:00:00	QQQ	ETF	55.67	55.68	55.6	55.6742	3537811.0
2011-01-05 14:00:00	QQQ	ETF	55.671	55.7	55.6	55.68	3507984.0
2011-01-05 15:00:00	QQQ	ETF	55.68	55.76	55.67	55.74	7221934.0
2011-01-05 16:00:00	QQQ	ETF	55.73	55.79	55.68	55.75	1292202.0
2011-01-05 17:00:00	QQQ	ETF	55.75	55.76	55.74	55.74	12525.0
2011-01-05 18:00:00	QQQ	ETF	55.75	55.79	55.75	55.78	16050.0
2011-01-05 19:00:00	QQQ	ETF	55.78	55.79	55.74	55.74	30179.0
2011-01-05 04:00:00	IWM	ETF	78.0	78.0	78.0	78.0	200.0
2011-01-05 05:00:00	IWM	ETF	77.9	77.9	77.9	77.9	4000.0
2011-01-05 06:00:00	IWM	ETF	77.98	77.98	77.73	77.78	16050.0
2011-01-05 07:00:00	IWM	ETF	77.76	77.9	77.76	77.85	48700.0
2011-01-05 08:00:00	IWM	ETF	77.88	78.32	77.88	78.25	804985.0
2011-01-05 09:00:00	IWM	ETF	78.25	78.47	78.1099	78.32	5462258.0
2011-01-05 10:00:00	IWM	ETF	78.33	78.83	78.318	78.66	7090417.0
2011-01-05 11:00:00	IWM	ETF	78.66	79.17	78.59	79.088	5708906.0
2011-01-05 12:00:00	IWM	ETF	79.09	79.19	78.95	79.02	3874760.0
2011-01-05 13:00:00	IWM	ETF	79.02	79.13	78.83	79.12	3691308.0
2011-01-05 14:00:00	IWM	ETF	79.12	79.23	79.02	79.22	3135120.0
2011-01-05 15:00:00	IWM	ETF	79.22	79.36	79.2	79.34	9606964.0
2011-01-05 16:00:00	IWM	ETF	79.33	79.3549	78.5216	79.21	2135656.0
2011-01-05 17:00:00	IWM	ETF	79.22	79.22	79.2	79.2	700.0
2011-01-05 18:00:00	IWM	ETF	79.24	79.26	79.24	79.24	1900.0
2011-01-05 19:00:00	IWM	ETF	79.27	79.3	79.24	79.24	7025.0
2011-01-05 05:00:00	DIA	ETF	115.99	115.99	115.99	115.99	100.0
2011-01-05 06:00:00	DIA	ETF	115.99	115.99	115.85	115.85	300.0

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

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