PREVIEW / etf_1hour / 2010-05-10

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-05-10.parquet
  size:    174 KB
  rows:    5,359

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-10 04:00:00	SPY	ETF	115.75	116.33	115.72	116.25	114059.0
2010-05-10 05:00:00	SPY	ETF	116.23	116.64	116.11	116.23	119323.0
2010-05-10 06:00:00	SPY	ETF	116.22	116.23	115.82	116.06	770462.0
2010-05-10 07:00:00	SPY	ETF	116.0	116.69	115.95	116.21	4322506.0
2010-05-10 08:00:00	SPY	ETF	116.2	116.5407	112.6	116.01	14519352.0
2010-05-10 09:00:00	SPY	ETF	116.01	116.65	114.21	115.98	77110068.0
2010-05-10 10:00:00	SPY	ETF	115.98	116.31	115.27	115.6	73026294.0
2010-05-10 11:00:00	SPY	ETF	115.6	116.43	115.58	116.24	40461579.0
2010-05-10 12:00:00	SPY	ETF	116.24	116.28	115.78	115.78	22885433.0
2010-05-10 13:00:00	SPY	ETF	115.79	116.56	115.02	115.2001	46177031.0
2010-05-10 14:00:00	SPY	ETF	115.2	115.72	114.91	115.69	32801509.0
2010-05-10 15:00:00	SPY	ETF	115.69	116.25	115.1	116.16	52817799.0
2010-05-10 16:00:00	SPY	ETF	116.15	116.56	111.309	116.26	22559885.0
2010-05-10 17:00:00	SPY	ETF	116.25	116.29	111.309	116.08	2180943.0
2010-05-10 18:00:00	SPY	ETF	116.07	116.17	116.03	116.1	82429.0
2010-05-10 19:00:00	SPY	ETF	116.11	116.11	115.98	116.02	155951.0
2010-05-10 04:00:00	QQQ	ETF	47.42	47.6	47.42	47.6	43280.0
2010-05-10 05:00:00	QQQ	ETF	47.59	47.73	47.55	47.62	80245.0
2010-05-10 06:00:00	QQQ	ETF	47.55	47.58	47.42	47.56	30866.0
2010-05-10 07:00:00	QQQ	ETF	47.45	47.62	47.38	47.42	645639.0
2010-05-10 08:00:00	QQQ	ETF	47.43	47.48	46.14	47.42	2109321.0
2010-05-10 09:00:00	QQQ	ETF	47.4	47.79	45.41	47.56	29106481.0
2010-05-10 10:00:00	QQQ	ETF	47.561	47.69	47.36	47.52	27823932.0
2010-05-10 11:00:00	QQQ	ETF	47.52	47.8	47.48	47.75	13754658.0
2010-05-10 12:00:00	QQQ	ETF	47.76	47.77	47.56	47.59	7390939.0
2010-05-10 13:00:00	QQQ	ETF	47.581	47.63	47.36	47.44	15031344.0
2010-05-10 14:00:00	QQQ	ETF	47.44	47.65	47.31	47.6285	10639274.0
2010-05-10 15:00:00	QQQ	ETF	47.62	47.78	47.41	47.76	18563066.0
2010-05-10 16:00:00	QQQ	ETF	47.76	47.86	47.43	47.82	5598336.0
2010-05-10 17:00:00	QQQ	ETF	47.83	47.8439	47.75	47.76	289384.0
2010-05-10 18:00:00	QQQ	ETF	47.76	47.78	47.74	47.78	15371.0
2010-05-10 19:00:00	QQQ	ETF	47.76	47.77	47.7	47.72	52883.0
2010-05-10 04:00:00	IWM	ETF	68.48	68.8	68.48	68.8	6862.0
2010-05-10 05:00:00	IWM	ETF	69.0	69.12	68.88	68.93	16265.0
2010-05-10 06:00:00	IWM	ETF	68.91	68.92	68.65	68.78	73869.0
2010-05-10 07:00:00	IWM	ETF	68.72	68.94	68.63	68.73	580039.0
2010-05-10 08:00:00	IWM	ETF	68.82	68.84	66.5	68.54	2789521.0
2010-05-10 09:00:00	IWM	ETF	68.53	69.0	68.18	68.65	19939606.0
2010-05-10 10:00:00	IWM	ETF	68.64	68.66	67.93	68.03	16815106.0
2010-05-10 11:00:00	IWM	ETF	68.02	68.7833	68.01	68.61	11938390.0
2010-05-10 12:00:00	IWM	ETF	68.62	68.6695	68.33	68.359	5003916.0
2010-05-10 13:00:00	IWM	ETF	68.36	68.45	67.92	68.09	10859123.0
2010-05-10 14:00:00	IWM	ETF	68.1	68.43	67.93	68.4	6676744.0
2010-05-10 15:00:00	IWM	ETF	68.4	69.06	68.21	69.03	20118098.0
2010-05-10 16:00:00	IWM	ETF	69.02	69.12	65.3359	69.08	7562901.0
2010-05-10 17:00:00	IWM	ETF	69.08	69.1	68.9	68.96	58121.0
2010-05-10 18:00:00	IWM	ETF	68.91	69.0	68.91	69.0	3327.0
2010-05-10 19:00:00	IWM	ETF	68.99	69.05	68.86	69.0	3500.0
2010-05-10 04:00:00	DIA	ETF	106.0	107.6	106.0	107.6	1600.0
2010-05-10 05:00:00	DIA	ETF	107.5	107.5	107.5	107.5	100.0

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

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