PREVIEW / etf_1hour / 2011-01-10

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-01-10.parquet
  size:    172 KB
  rows:    5,288

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-10 04:00:00	SPY	ETF	126.5	126.65	126.49	126.63	2660.0
2011-01-10 05:00:00	SPY	ETF	126.51	126.51	126.23	126.48	54205.0
2011-01-10 06:00:00	SPY	ETF	126.48	126.59	126.38	126.54	83400.0
2011-01-10 07:00:00	SPY	ETF	126.55	126.62	126.41	126.49	620979.0
2011-01-10 08:00:00	SPY	ETF	126.49	126.68	126.4	126.59	953187.0
2011-01-10 09:00:00	SPY	ETF	126.6	126.81	126.2	126.25	16404408.0
2011-01-10 10:00:00	SPY	ETF	126.25	126.89	126.2	126.55	25203988.0
2011-01-10 11:00:00	SPY	ETF	126.55	126.83	126.37	126.8	16071301.0
2011-01-10 12:00:00	SPY	ETF	126.8	126.92	126.61	126.79	14666418.0
2011-01-10 13:00:00	SPY	ETF	126.785	127.0	126.78	126.91	9154528.0
2011-01-10 14:00:00	SPY	ETF	126.91	127.05	126.73	127.02	10449989.0
2011-01-10 15:00:00	SPY	ETF	127.02	127.16	126.92	126.98	17424538.0
2011-01-10 16:00:00	SPY	ETF	127.01	127.15	126.342	126.91	9492557.0
2011-01-10 17:00:00	SPY	ETF	126.88	126.96	126.87	126.94	239644.0
2011-01-10 18:00:00	SPY	ETF	126.94	127.02	126.89	127.02	97664.0
2011-01-10 19:00:00	SPY	ETF	127.02	127.06	126.85	126.86	105682.0
2011-01-10 04:00:00	QQQ	ETF	55.64	55.64	55.64	55.64	200.0
2011-01-10 05:00:00	QQQ	ETF	55.57	55.58	55.56	55.58	400.0
2011-01-10 06:00:00	QQQ	ETF	55.61	55.67	55.59	55.59	44200.0
2011-01-10 07:00:00	QQQ	ETF	55.63	55.68	55.62	55.63	59163.0
2011-01-10 08:00:00	QQQ	ETF	55.63	55.87	55.6	55.7	310122.0
2011-01-10 09:00:00	QQQ	ETF	55.71	55.89	55.6	55.65	9688785.0
2011-01-10 10:00:00	QQQ	ETF	55.64	55.89	55.58	55.74	12026813.0
2011-01-10 11:00:00	QQQ	ETF	55.7436	55.9	55.7	55.9	5075011.0
2011-01-10 12:00:00	QQQ	ETF	55.8919	55.95	55.8	55.87	6353647.0
2011-01-10 13:00:00	QQQ	ETF	55.86	56.06	55.86	56.0	3449622.0
2011-01-10 14:00:00	QQQ	ETF	56.0	56.07	55.94	56.05	3061582.0
2011-01-10 15:00:00	QQQ	ETF	56.0558	56.18	56.03	56.07	7240091.0
2011-01-10 16:00:00	QQQ	ETF	56.08	56.1326	56.01	56.05	906309.0
2011-01-10 17:00:00	QQQ	ETF	56.04	56.06	56.0	56.05	606658.0
2011-01-10 18:00:00	QQQ	ETF	56.05	56.06	56.03	56.06	8784.0
2011-01-10 19:00:00	QQQ	ETF	56.08	56.1	56.02	56.02	47883.0
2011-01-10 04:00:00	IWM	ETF	78.08	78.08	78.05	78.08	2789.0
2011-01-10 05:00:00	IWM	ETF	78.01	78.01	77.99	77.99	4600.0
2011-01-10 06:00:00	IWM	ETF	78.01	78.06	78.01	78.04	1700.0
2011-01-10 07:00:00	IWM	ETF	78.09	78.12	78.01	78.03	15150.0
2011-01-10 08:00:00	IWM	ETF	78.03	78.22	77.99	78.21	273745.0
2011-01-10 09:00:00	IWM	ETF	78.2	78.4699	77.62	77.75	6588497.0
2011-01-10 10:00:00	IWM	ETF	77.75	78.42	77.68	78.01	10192988.0
2011-01-10 11:00:00	IWM	ETF	78.01	78.59	77.79	78.55	6698774.0
2011-01-10 12:00:00	IWM	ETF	78.56	78.67	78.13	78.5474	6276067.0
2011-01-10 13:00:00	IWM	ETF	78.55	79.02	78.49	78.97	3506184.0
2011-01-10 14:00:00	IWM	ETF	78.98	79.0	78.65	78.975	4426806.0
2011-01-10 15:00:00	IWM	ETF	78.98	79.29	78.92	78.97	8472092.0
2011-01-10 16:00:00	IWM	ETF	78.96	79.1553	78.93	78.93	986550.0
2011-01-10 17:00:00	IWM	ETF	78.95	78.99	78.92	78.95	21102.0
2011-01-10 18:00:00	IWM	ETF	78.96	78.97	78.96	78.97	1500.0
2011-01-10 19:00:00	IWM	ETF	79.01	79.04	78.96	78.96	2200.0
2011-01-10 05:00:00	DIA	ETF	116.12	116.12	116.12	116.12	100.0
2011-01-10 07:00:00	DIA	ETF	116.13	116.21	116.13	116.17	7000.0

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

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