PREVIEW / etf_1hour / 2010-09-24

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-09-24.parquet
  size:    169 KB
  rows:    5,150

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-09-24 04:00:00	SPY	ETF	112.9	113.05	112.75	112.91	19300.0
2010-09-24 05:00:00	SPY	ETF	112.86	112.94	112.86	112.94	700.0
2010-09-24 06:00:00	SPY	ETF	112.73	112.81	112.69	112.76	31050.0
2010-09-24 07:00:00	SPY	ETF	112.82	113.02	112.82	112.96	257661.0
2010-09-24 08:00:00	SPY	ETF	112.96	113.89	112.93	113.76	5958024.0
2010-09-24 09:00:00	SPY	ETF	113.77	114.34	112.5	114.2475	26643379.0
2010-09-24 10:00:00	SPY	ETF	114.25	114.71	114.08	114.53	38057700.0
2010-09-24 11:00:00	SPY	ETF	114.52	114.76	114.43	114.6	20012925.0
2010-09-24 12:00:00	SPY	ETF	114.61	114.79	114.5	114.73	12887541.0
2010-09-24 13:00:00	SPY	ETF	114.73	114.89	114.65	114.6881	14218945.0
2010-09-24 14:00:00	SPY	ETF	114.68	114.89	114.55	114.78	20212145.0
2010-09-24 15:00:00	SPY	ETF	114.78	114.9	114.61	114.8	34804596.0
2010-09-24 16:00:00	SPY	ETF	114.8	114.89	112.462	114.85	28551988.0
2010-09-24 17:00:00	SPY	ETF	114.85	114.88	114.75	114.86	5273491.0
2010-09-24 18:00:00	SPY	ETF	114.87	114.87	114.77	114.86	23404.0
2010-09-24 19:00:00	SPY	ETF	114.84	114.92	114.79	114.88	50492.0
2010-09-24 04:00:00	QQQ	ETF	48.97	49.0	48.85	48.92	5938.0
2010-09-24 05:00:00	QQQ	ETF	48.92	48.96	48.92	48.96	601.0
2010-09-24 06:00:00	QQQ	ETF	48.9	48.9	48.89	48.89	200.0
2010-09-24 07:00:00	QQQ	ETF	48.95	48.99	48.93	48.95	132829.0
2010-09-24 08:00:00	QQQ	ETF	48.96	49.36	48.96	49.25	1655821.0
2010-09-24 09:00:00	QQQ	ETF	49.26	49.42	49.15	49.371	9383282.0
2010-09-24 10:00:00	QQQ	ETF	49.38	49.5699	49.32	49.515	13030135.0
2010-09-24 11:00:00	QQQ	ETF	49.52	49.65	49.49	49.61	8605442.0
2010-09-24 12:00:00	QQQ	ETF	49.6	49.69	49.54	49.64	4372692.0
2010-09-24 13:00:00	QQQ	ETF	49.64	49.67	49.55	49.56	5696535.0
2010-09-24 14:00:00	QQQ	ETF	49.56	49.65	49.5	49.58	9452970.0
2010-09-24 15:00:00	QQQ	ETF	49.59	49.67	49.53	49.65	14951392.0
2010-09-24 16:00:00	QQQ	ETF	49.65	49.67	49.5309	49.63	2541938.0
2010-09-24 17:00:00	QQQ	ETF	49.64	49.65	49.63	49.65	11846.0
2010-09-24 18:00:00	QQQ	ETF	49.65	49.67	49.63	49.65	60299.0
2010-09-24 19:00:00	QQQ	ETF	49.66	49.69	49.65	49.69	10198.0
2010-09-24 04:00:00	IWM	ETF	65.3	65.3	65.1	65.1	600.0
2010-09-24 05:00:00	IWM	ETF	65.3	65.3	65.3	65.3	980.0
2010-09-24 07:00:00	IWM	ETF	65.32	65.35	65.25	65.29	49200.0
2010-09-24 08:00:00	IWM	ETF	65.29	65.95	65.28	65.8	1056437.0
2010-09-24 09:00:00	IWM	ETF	65.81	66.11	65.69	65.9	7096324.0
2010-09-24 10:00:00	IWM	ETF	65.89	66.35	65.74	66.2301	10549167.0
2010-09-24 11:00:00	IWM	ETF	66.23	66.42	66.14	66.35	7148985.0
2010-09-24 12:00:00	IWM	ETF	66.35	66.55	66.26	66.49	4000903.0
2010-09-24 13:00:00	IWM	ETF	66.49	66.75	66.43	66.6	7352316.0
2010-09-24 14:00:00	IWM	ETF	66.6	66.92	66.51	66.91	5456322.0
2010-09-24 15:00:00	IWM	ETF	66.9	67.06	66.815	66.96	16195282.0
2010-09-24 16:00:00	IWM	ETF	66.95	67.0492	64.8439	66.94	9629630.0
2010-09-24 17:00:00	IWM	ETF	66.97	66.98	66.93	66.98	6200.0
2010-09-24 18:00:00	IWM	ETF	66.95	66.95	66.93	66.95	900.0
2010-09-24 19:00:00	IWM	ETF	66.92	66.97	66.92	66.97	600.0
2010-09-24 07:00:00	DIA	ETF	107.17	107.17	107.09	107.1	10100.0
2010-09-24 08:00:00	DIA	ETF	107.14	107.88	107.13	107.77	98063.0
2010-09-24 09:00:00	DIA	ETF	107.8	108.32	107.67	108.21	1068926.0

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

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