PREVIEW / etf_1hour / 2012-01-17

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-01-17.parquet
  size:    187 KB
  rows:    5,846

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
2012-01-17 04:00:00	SPY	ETF	130.1	130.61	130.1	130.61	11650.0
2012-01-17 05:00:00	SPY	ETF	130.63	130.65	130.41	130.51	17085.0
2012-01-17 06:00:00	SPY	ETF	130.4	130.49	130.29	130.34	226732.0
2012-01-17 07:00:00	SPY	ETF	130.34	130.56	130.28	130.34	642573.0
2012-01-17 08:00:00	SPY	ETF	130.34	130.56	130.1	130.13	2664011.0
2012-01-17 09:00:00	SPY	ETF	130.14	130.32	129.98	130.0501	19892062.0
2012-01-17 10:00:00	SPY	ETF	130.05	130.065	129.71	129.855	22833121.0
2012-01-17 11:00:00	SPY	ETF	129.85	130.08	129.83	130.0	11706278.0
2012-01-17 12:00:00	SPY	ETF	130.0	130.13	129.71	129.84	11581788.0
2012-01-17 13:00:00	SPY	ETF	129.83	129.93	129.73	129.86	7022184.0
2012-01-17 14:00:00	SPY	ETF	129.85	129.9	129.3	129.39	13602316.0
2012-01-17 15:00:00	SPY	ETF	129.39	129.43	129.06	129.33	28935589.0
2012-01-17 16:00:00	SPY	ETF	129.32	129.7548	129.28	129.46	11381810.0
2012-01-17 17:00:00	SPY	ETF	129.5	129.56	129.42	129.44	155284.0
2012-01-17 18:00:00	SPY	ETF	129.46	129.57	129.31	129.57	171374.0
2012-01-17 19:00:00	SPY	ETF	129.56	129.59	129.46	129.47	110636.0
2012-01-17 04:00:00	QQQ	ETF	58.52	58.96	58.52	58.96	3383.0
2012-01-17 05:00:00	QQQ	ETF	58.87	58.87	58.85	58.85	1100.0
2012-01-17 06:00:00	QQQ	ETF	58.83	58.85	58.77	58.77	8846.0
2012-01-17 07:00:00	QQQ	ETF	58.76	58.91	58.76	58.85	77140.0
2012-01-17 08:00:00	QQQ	ETF	58.82	58.89	58.69	58.71	230019.0
2012-01-17 09:00:00	QQQ	ETF	58.72	58.84	58.65	58.78	4097261.0
2012-01-17 10:00:00	QQQ	ETF	58.7867	58.89	58.7	58.85	5515509.0
2012-01-17 11:00:00	QQQ	ETF	58.86	58.96	58.84	58.8901	3292000.0
2012-01-17 12:00:00	QQQ	ETF	58.8901	58.96	58.78	58.835	3334765.0
2012-01-17 13:00:00	QQQ	ETF	58.8301	58.89	58.77	58.849	2751398.0
2012-01-17 14:00:00	QQQ	ETF	58.84	58.87	58.67	58.7101	2894413.0
2012-01-17 15:00:00	QQQ	ETF	58.715	58.73	58.49	58.67	10998450.0
2012-01-17 16:00:00	QQQ	ETF	58.69	58.74	58.6476	58.74	1179867.0
2012-01-17 17:00:00	QQQ	ETF	58.74	58.79	58.74	58.74	68425.0
2012-01-17 18:00:00	QQQ	ETF	58.75	58.77	58.74	58.76	51838.0
2012-01-17 19:00:00	QQQ	ETF	58.77	58.78	58.75	58.77	17136.0
2012-01-17 04:00:00	IWM	ETF	77.36	77.36	77.36	77.36	300.0
2012-01-17 06:00:00	IWM	ETF	77.45	77.45	77.4	77.4	800.0
2012-01-17 07:00:00	IWM	ETF	77.3	77.48	77.28	77.41	14280.0
2012-01-17 08:00:00	IWM	ETF	77.39	77.47	77.09	77.11	217709.0
2012-01-17 09:00:00	IWM	ETF	77.12	77.27	76.89	76.94	3510623.0
2012-01-17 10:00:00	IWM	ETF	76.95	76.95	76.599	76.73	5158231.0
2012-01-17 11:00:00	IWM	ETF	76.74	76.96	76.73	76.8699	2473336.0
2012-01-17 12:00:00	IWM	ETF	76.87	77.0	76.67	76.8008	1869765.0
2012-01-17 13:00:00	IWM	ETF	76.8	76.95	76.76	76.88	2135625.0
2012-01-17 14:00:00	IWM	ETF	76.88	76.88	76.48	76.49	2321357.0
2012-01-17 15:00:00	IWM	ETF	76.49	76.53	76.13	76.33	6120075.0
2012-01-17 16:00:00	IWM	ETF	76.34	76.4	76.28	76.39	9220433.0
2012-01-17 17:00:00	IWM	ETF	76.4	76.5	76.38	76.44	23900.0
2012-01-17 18:00:00	IWM	ETF	76.44	76.44	76.43	76.43	400.0
2012-01-17 19:00:00	IWM	ETF	76.45	76.45	76.34	76.34	2700.0
2012-01-17 04:00:00	DIA	ETF	124.8	124.8	124.8	124.8	200.0
2012-01-17 07:00:00	DIA	ETF	125.15	125.39	125.15	125.39	1000.0
2012-01-17 08:00:00	DIA	ETF	125.26	125.39	124.75	125.09	21960.0

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

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