PREVIEW / etf_1hour / 2010-04-06

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-04-06.parquet
  size:    157 KB
  rows:    4,848

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-04-06 04:00:00	SPY	ETF	118.54	118.54	118.52	118.53	1000.0
2010-04-06 05:00:00	SPY	ETF	118.49	118.5	118.48	118.5	4500.0
2010-04-06 06:00:00	SPY	ETF	118.48	118.56	118.45	118.53	5600.0
2010-04-06 07:00:00	SPY	ETF	118.55	118.6	118.49	118.54	197480.0
2010-04-06 08:00:00	SPY	ETF	118.54	118.54	118.22	118.26	1617979.0
2010-04-06 09:00:00	SPY	ETF	118.25	118.59	118.2	118.52	16607891.0
2010-04-06 10:00:00	SPY	ETF	118.52	118.75	118.42	118.7	16858336.0
2010-04-06 11:00:00	SPY	ETF	118.71	118.91	118.64	118.78	13605571.0
2010-04-06 12:00:00	SPY	ETF	118.78	118.86	118.69	118.8	8603926.0
2010-04-06 13:00:00	SPY	ETF	118.8	118.91	118.76	118.8	6773427.0
2010-04-06 14:00:00	SPY	ETF	118.8	119.25	118.79	119.15	20053070.0
2010-04-06 15:00:00	SPY	ETF	119.15	119.19	118.92	119.01	19771757.0
2010-04-06 16:00:00	SPY	ETF	119.01	119.19	118.5	118.98	4894805.0
2010-04-06 17:00:00	SPY	ETF	118.97	119.0	118.94	118.95	100420.0
2010-04-06 18:00:00	SPY	ETF	118.96	118.99	118.94	118.96	48504.0
2010-04-06 19:00:00	SPY	ETF	118.95	118.96	118.84	118.9	140720.0
2010-04-06 04:00:00	QQQ	ETF	48.54	48.54	48.54	48.54	200.0
2010-04-06 05:00:00	QQQ	ETF	48.48	48.48	48.48	48.48	4000.0
2010-04-06 07:00:00	QQQ	ETF	48.52	48.52	48.49	48.49	3761.0
2010-04-06 08:00:00	QQQ	ETF	48.49	48.51	48.4	48.44	506920.0
2010-04-06 09:00:00	QQQ	ETF	48.44	48.54	48.39	48.49	7105535.0
2010-04-06 10:00:00	QQQ	ETF	48.48	48.58	48.43	48.52	9347938.0
2010-04-06 11:00:00	QQQ	ETF	48.53	48.64	48.48	48.61	5330957.0
2010-04-06 12:00:00	QQQ	ETF	48.6101	48.65	48.5	48.64	2695966.0
2010-04-06 13:00:00	QQQ	ETF	48.6385	48.69	48.62	48.65	3615643.0
2010-04-06 14:00:00	QQQ	ETF	48.66	48.9	48.64	48.835	10482608.0
2010-04-06 15:00:00	QQQ	ETF	48.8376	48.85	48.71	48.74	7957611.0
2010-04-06 16:00:00	QQQ	ETF	48.75	48.82	48.4918	48.7	3056982.0
2010-04-06 17:00:00	QQQ	ETF	48.71	48.72	48.67	48.71	37254.0
2010-04-06 18:00:00	QQQ	ETF	48.7	48.71	48.68	48.68	8153.0
2010-04-06 19:00:00	QQQ	ETF	48.69	48.69	48.66	48.68	48597.0
2010-04-06 06:00:00	IWM	ETF	69.44	69.44	69.44	69.44	1500.0
2010-04-06 07:00:00	IWM	ETF	69.44	69.51	69.44	69.49	41401.0
2010-04-06 08:00:00	IWM	ETF	69.5	69.51	69.3	69.36	301595.0
2010-04-06 09:00:00	IWM	ETF	69.36	69.64	69.3	69.6	7521351.0
2010-04-06 10:00:00	IWM	ETF	69.61	69.85	69.52	69.82	7163828.0
2010-04-06 11:00:00	IWM	ETF	69.81	70.03	69.77	69.9218	6704260.0
2010-04-06 12:00:00	IWM	ETF	69.92	69.96	69.81	69.95	2301523.0
2010-04-06 13:00:00	IWM	ETF	69.95	70.0	69.85	69.91	2795010.0
2010-04-06 14:00:00	IWM	ETF	69.92	70.27	69.915	70.24	6410095.0
2010-04-06 15:00:00	IWM	ETF	70.24	70.29	70.02	70.11	9692986.0
2010-04-06 16:00:00	IWM	ETF	70.11	70.2646	67.82	70.06	5120609.0
2010-04-06 17:00:00	IWM	ETF	70.09	70.11	70.05	70.06	14967.0
2010-04-06 18:00:00	IWM	ETF	70.07	70.07	70.07	70.07	700.0
2010-04-06 19:00:00	IWM	ETF	70.07	70.07	70.05	70.05	23205.0
2010-04-06 06:00:00	DIA	ETF	109.57	109.57	109.57	109.57	100.0
2010-04-06 07:00:00	DIA	ETF	109.61	109.61	109.57	109.59	550.0
2010-04-06 08:00:00	DIA	ETF	109.55	109.57	109.33	109.37	28600.0
2010-04-06 09:00:00	DIA	ETF	109.36	109.5	109.2782	109.46	772798.0
2010-04-06 10:00:00	DIA	ETF	109.46	109.57	109.37	109.55	716453.0

> showing 50 of 4,848 rows — these rows as CSV

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