PREVIEW / etf_1hour / 2010-05-26

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-05-26.parquet
  size:    170 KB
  rows:    5,178

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-05-26 04:00:00	SPY	ETF	108.34	108.39	108.2	108.39	2242.0
2010-05-26 05:00:00	SPY	ETF	108.47	108.7	108.4	108.4	34090.0
2010-05-26 06:00:00	SPY	ETF	108.4	108.54	108.2	108.51	71500.0
2010-05-26 07:00:00	SPY	ETF	108.5	108.84	108.5	108.76	578861.0
2010-05-26 08:00:00	SPY	ETF	108.78	109.08	108.5	108.56	5098282.0
2010-05-26 09:00:00	SPY	ETF	108.56	109.25	108.39	109.14	50751743.0
2010-05-26 10:00:00	SPY	ETF	109.14	109.47	108.7	109.0	58225428.0
2010-05-26 11:00:00	SPY	ETF	109.0	109.11	108.18	108.61	43031730.0
2010-05-26 12:00:00	SPY	ETF	108.61	108.96	108.4	108.88	19641856.0
2010-05-26 13:00:00	SPY	ETF	108.88	109.18	108.69	108.95	16254731.0
2010-05-26 14:00:00	SPY	ETF	108.95	109.05	107.7791	108.24	42275771.0
2010-05-26 15:00:00	SPY	ETF	108.24	108.65	106.85	107.15	82912296.0
2010-05-26 16:00:00	SPY	ETF	107.14	109.4	106.42	106.74	19959948.0
2010-05-26 17:00:00	SPY	ETF	106.73	109.01	106.1	106.45	1855426.0
2010-05-26 18:00:00	SPY	ETF	106.46	107.17	106.15	106.5	502101.0
2010-05-26 19:00:00	SPY	ETF	106.51	106.86	106.44	106.83	378004.0
2010-05-26 04:00:00	QQQ	ETF	44.91	45.0	44.91	45.0	1400.0
2010-05-26 05:00:00	QQQ	ETF	45.01	45.08	44.93	44.93	1600.0
2010-05-26 06:00:00	QQQ	ETF	44.95	45.02	44.87	45.02	24473.0
2010-05-26 07:00:00	QQQ	ETF	45.0	45.13	45.0	45.11	133640.0
2010-05-26 08:00:00	QQQ	ETF	45.11	45.24	44.97	45.02	1465565.0
2010-05-26 09:00:00	QQQ	ETF	45.02	45.44	44.91	45.3896	21289827.0
2010-05-26 10:00:00	QQQ	ETF	45.3801	45.57	45.25	45.3219	17317264.0
2010-05-26 11:00:00	QQQ	ETF	45.32	45.35	44.92	45.09	12710392.0
2010-05-26 12:00:00	QQQ	ETF	45.09	45.21	44.97	45.1585	7825484.0
2010-05-26 13:00:00	QQQ	ETF	45.16	45.25	45.076	45.15	6049183.0
2010-05-26 14:00:00	QQQ	ETF	45.15	45.19	44.6	44.79	17163170.0
2010-05-26 15:00:00	QQQ	ETF	44.7899	44.89	44.12	44.22	36247369.0
2010-05-26 16:00:00	QQQ	ETF	44.21	45.5563	44.0	44.7055	8437422.0
2010-05-26 17:00:00	QQQ	ETF	44.16	44.7054	43.93	44.01	1195619.0
2010-05-26 18:00:00	QQQ	ETF	44.0	44.05	43.94	44.03	85125.0
2010-05-26 19:00:00	QQQ	ETF	44.07	44.17	44.03	44.15	38161.0
2010-05-26 04:00:00	IWM	ETF	64.29	64.5	64.26	64.45	16532.0
2010-05-26 05:00:00	IWM	ETF	64.45	64.45	64.3	64.3	2000.0
2010-05-26 06:00:00	IWM	ETF	64.28	64.28	64.2	64.2	1900.0
2010-05-26 07:00:00	IWM	ETF	64.5	64.76	64.46	64.67	94463.0
2010-05-26 08:00:00	IWM	ETF	64.69	64.94	64.54	64.6	1811730.0
2010-05-26 09:00:00	IWM	ETF	64.6	65.6	64.4	65.53	14326930.0
2010-05-26 10:00:00	IWM	ETF	65.53	65.95	65.4	65.49	16304520.0
2010-05-26 11:00:00	IWM	ETF	65.49	65.57	64.94	65.22	9411856.0
2010-05-26 12:00:00	IWM	ETF	65.22	65.45	65.14	65.43	4047505.0
2010-05-26 13:00:00	IWM	ETF	65.44	65.67	65.42	65.52	3729471.0
2010-05-26 14:00:00	IWM	ETF	65.51	65.6	64.66	64.9	12781770.0
2010-05-26 15:00:00	IWM	ETF	64.9	65.2	63.98	64.32	24646233.0
2010-05-26 16:00:00	IWM	ETF	64.3	64.75	63.8	64.0	7762886.0
2010-05-26 17:00:00	IWM	ETF	64.0	64.0774	63.64	63.71	3069505.0
2010-05-26 18:00:00	IWM	ETF	63.73	63.8	63.6	63.72	34311.0
2010-05-26 19:00:00	IWM	ETF	63.82	63.98	63.72	63.98	3651.0
2010-05-26 07:00:00	DIA	ETF	101.0	101.24	101.0	101.18	6900.0
2010-05-26 08:00:00	DIA	ETF	101.22	101.45	101.02	101.02	82539.0

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

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