PREVIEW / etf_1hour / 2010-11-09

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-11-09.parquet
  size:    180 KB
  rows:    5,447

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-11-09 04:00:00	SPY	ETF	122.25	122.45	122.2	122.45	1930.0
2010-11-09 05:00:00	SPY	ETF	122.45	122.75	122.45	122.68	23860.0
2010-11-09 06:00:00	SPY	ETF	122.62	122.79	122.6	122.79	20850.0
2010-11-09 07:00:00	SPY	ETF	122.79	122.88	122.73	122.76	332809.0
2010-11-09 08:00:00	SPY	ETF	122.76	122.81	122.39	122.72	931209.0
2010-11-09 09:00:00	SPY	ETF	122.75	122.82	122.1	122.65	18506522.0
2010-11-09 10:00:00	SPY	ETF	122.65	122.95	122.5	122.62	25621469.0
2010-11-09 11:00:00	SPY	ETF	122.62	122.65	122.17	122.18	16668085.0
2010-11-09 12:00:00	SPY	ETF	122.18	122.33	122.11	122.17	12623503.0
2010-11-09 13:00:00	SPY	ETF	122.18	122.42	121.71	121.865	23978692.0
2010-11-09 14:00:00	SPY	ETF	121.8699	122.17	121.84	122.02	19197655.0
2010-11-09 15:00:00	SPY	ETF	122.02	122.03	121.12	121.6	56389372.0
2010-11-09 16:00:00	SPY	ETF	121.59	122.795	121.27	121.52	10104804.0
2010-11-09 17:00:00	SPY	ETF	121.51	121.53	121.44	121.52	225872.0
2010-11-09 18:00:00	SPY	ETF	121.52	121.6	121.36	121.59	533789.0
2010-11-09 19:00:00	SPY	ETF	121.59	121.68	121.52	121.68	104165.0
2010-11-09 04:00:00	QQQ	ETF	53.71	53.71	53.71	53.71	200.0
2010-11-09 05:00:00	QQQ	ETF	53.83	53.9	53.83	53.88	945.0
2010-11-09 06:00:00	QQQ	ETF	53.86	53.92	53.86	53.92	18388.0
2010-11-09 07:00:00	QQQ	ETF	53.92	53.98	53.91	53.94	126910.0
2010-11-09 08:00:00	QQQ	ETF	53.9	53.93	53.85	53.9	1433312.0
2010-11-09 09:00:00	QQQ	ETF	53.9	53.97	53.7	53.7904	6097388.0
2010-11-09 10:00:00	QQQ	ETF	53.79	54.0401	53.77	53.91	8019181.0
2010-11-09 11:00:00	QQQ	ETF	53.9	53.915	53.62	53.63	8484173.0
2010-11-09 12:00:00	QQQ	ETF	53.62	53.72	53.62	53.67	3834686.0
2010-11-09 13:00:00	QQQ	ETF	53.67	53.78	53.46	53.56	7051179.0
2010-11-09 14:00:00	QQQ	ETF	53.57	53.68	53.55	53.62	3138318.0
2010-11-09 15:00:00	QQQ	ETF	53.62	53.62	53.21	53.44	14562530.0
2010-11-09 16:00:00	QQQ	ETF	53.44	53.51	53.44	53.46	3628405.0
2010-11-09 17:00:00	QQQ	ETF	53.47	53.47	53.37	53.43	12314.0
2010-11-09 18:00:00	QQQ	ETF	53.45	53.49	53.39	53.48	51200.0
2010-11-09 19:00:00	QQQ	ETF	53.48	53.53	53.45	53.5	23104.0
2010-11-09 04:00:00	IWM	ETF	73.68	73.68	73.68	73.68	1000.0
2010-11-09 05:00:00	IWM	ETF	73.66	73.66	73.66	73.66	200.0
2010-11-09 06:00:00	IWM	ETF	73.77	73.85	73.77	73.85	9400.0
2010-11-09 07:00:00	IWM	ETF	73.86	73.91	73.81	73.82	32800.0
2010-11-09 08:00:00	IWM	ETF	73.91	73.91	73.74	73.81	99137.0
2010-11-09 09:00:00	IWM	ETF	73.8	73.94	73.59	73.76	4024109.0
2010-11-09 10:00:00	IWM	ETF	73.76	74.05	73.62	73.71	6886067.0
2010-11-09 11:00:00	IWM	ETF	73.71	73.75	73.27	73.27	4972709.0
2010-11-09 12:00:00	IWM	ETF	73.27	73.45	73.2	73.2401	3322629.0
2010-11-09 13:00:00	IWM	ETF	73.25	73.49	72.92	73.04	5428054.0
2010-11-09 14:00:00	IWM	ETF	73.04	73.25	73.01	73.14	3279633.0
2010-11-09 15:00:00	IWM	ETF	73.14	73.15	72.33	72.73	12498201.0
2010-11-09 16:00:00	IWM	ETF	72.73	73.7277	72.5407	72.7	3728216.0
2010-11-09 17:00:00	IWM	ETF	72.68	72.68	72.6	72.64	7594.0
2010-11-09 18:00:00	IWM	ETF	72.66	72.68	72.62	72.65	14914.0
2010-11-09 19:00:00	IWM	ETF	72.67	72.74	72.61	72.74	5443.0
2010-11-09 06:00:00	DIA	ETF	114.43	114.5	114.43	114.5	4000.0
2010-11-09 07:00:00	DIA	ETF	114.53	114.57	114.51	114.55	18390.0

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

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