PREVIEW / etf_1hour / 2011-01-28

all etf 1-hour files

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

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-28 04:00:00	SPY	ETF	129.7	129.75	129.62	129.75	7200.0
2011-01-28 05:00:00	SPY	ETF	129.86	129.86	129.82	129.83	11100.0
2011-01-28 06:00:00	SPY	ETF	129.85	129.96	129.85	129.96	12400.0
2011-01-28 07:00:00	SPY	ETF	129.94	130.08	129.89	130.03	480060.0
2011-01-28 08:00:00	SPY	ETF	130.01	130.24	129.83	130.04	2034055.0
2011-01-28 09:00:00	SPY	ETF	130.03	130.35	129.93	129.96	18371209.0
2011-01-28 10:00:00	SPY	ETF	129.94	129.97	128.86	128.89	40547127.0
2011-01-28 11:00:00	SPY	ETF	128.9	129.02	128.05	128.15	46047742.0
2011-01-28 12:00:00	SPY	ETF	128.14	128.34	127.68	128.24	41900295.0
2011-01-28 13:00:00	SPY	ETF	128.24	128.25	127.63	128.17	26824370.0
2011-01-28 14:00:00	SPY	ETF	128.18	128.24	127.85	128.045	23018274.0
2011-01-28 15:00:00	SPY	ETF	128.0491	128.14	127.51	127.69	47214322.0
2011-01-28 16:00:00	SPY	ETF	127.69	130.01	127.46	127.54	22989459.0
2011-01-28 17:00:00	SPY	ETF	127.53	127.6929	127.48	127.5	25639956.0
2011-01-28 18:00:00	SPY	ETF	127.5	127.72	127.46	127.48	96233.0
2011-01-28 19:00:00	SPY	ETF	127.47	127.51	127.41	127.42	31763.0
2011-01-28 05:00:00	QQQ	ETF	56.97	57.0	56.97	57.0	30000.0
2011-01-28 06:00:00	QQQ	ETF	56.99	57.09	56.99	57.08	47300.0
2011-01-28 07:00:00	QQQ	ETF	57.05	57.14	57.03	57.11	21747.0
2011-01-28 08:00:00	QQQ	ETF	57.11	57.26	57.03	57.17	960221.0
2011-01-28 09:00:00	QQQ	ETF	57.17	57.23	56.97	56.98	7405640.0
2011-01-28 10:00:00	QQQ	ETF	56.98	56.99	56.38	56.4381	15773452.0
2011-01-28 11:00:00	QQQ	ETF	56.43	56.46	55.7	55.76	20414732.0
2011-01-28 12:00:00	QQQ	ETF	55.76	55.92	55.47	55.89	15282445.0
2011-01-28 13:00:00	QQQ	ETF	55.9	55.9	55.6	55.85	10974143.0
2011-01-28 14:00:00	QQQ	ETF	55.85	55.92	55.73	55.8125	5979278.0
2011-01-28 15:00:00	QQQ	ETF	55.8191	55.84	55.61	55.73	15740696.0
2011-01-28 16:00:00	QQQ	ETF	55.74	55.79	55.64	55.7	2303917.0
2011-01-28 17:00:00	QQQ	ETF	55.69	57.1938	55.69	55.7	12073659.0
2011-01-28 18:00:00	QQQ	ETF	55.7	55.73	55.67	55.69	19200.0
2011-01-28 19:00:00	QQQ	ETF	55.68	55.71	55.65	55.7	18900.0
2011-01-28 07:00:00	IWM	ETF	79.25	79.34	79.23	79.33	8800.0
2011-01-28 08:00:00	IWM	ETF	79.29	79.47	79.2	79.33	357919.0
2011-01-28 09:00:00	IWM	ETF	79.3	79.45	79.07	79.09	5357838.0
2011-01-28 10:00:00	IWM	ETF	79.1	79.12	78.0	78.08	14633842.0
2011-01-28 11:00:00	IWM	ETF	78.07	78.27	77.5	77.56	11466197.0
2011-01-28 12:00:00	IWM	ETF	77.56	77.97	77.33	77.84	8394874.0
2011-01-28 13:00:00	IWM	ETF	77.84	77.84	77.48	77.78	7408866.0
2011-01-28 14:00:00	IWM	ETF	77.77	77.87	77.59	77.78	6010739.0
2011-01-28 15:00:00	IWM	ETF	77.78	79.4157	77.36	77.408	18044455.0
2011-01-28 16:00:00	IWM	ETF	77.41	77.8	77.34	77.42	3026765.0
2011-01-28 17:00:00	IWM	ETF	77.4	77.45	77.35	77.36	51300.0
2011-01-28 18:00:00	IWM	ETF	77.36	77.38	77.34	77.36	5500.0
2011-01-28 19:00:00	IWM	ETF	77.37	77.39	77.34	77.34	2000.0
2011-01-28 07:00:00	DIA	ETF	119.62	119.62	119.58	119.62	2900.0
2011-01-28 08:00:00	DIA	ETF	119.78	119.85	119.61	119.65	41190.0
2011-01-28 09:00:00	DIA	ETF	119.67	119.86	119.62	119.62	906397.0
2011-01-28 10:00:00	DIA	ETF	119.63	119.6438	118.876	118.91	1986303.0
2011-01-28 11:00:00	DIA	ETF	118.89	119.05	118.19	118.27	3375943.0
2011-01-28 12:00:00	DIA	ETF	118.27	118.37	117.86	118.27	3059775.0

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

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