PREVIEW / etf_1hour / 2009-03-16

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-03-16.parquet
  size:    131 KB
  rows:    4,040

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
2009-03-16 04:00:00	SPY	ETF	76.83	77.03	76.63	77.0	14030.0
2009-03-16 05:00:00	SPY	ETF	76.82	77.31	76.8	77.31	90790.0
2009-03-16 06:00:00	SPY	ETF	77.28	77.33	77.06	77.06	207944.0
2009-03-16 07:00:00	SPY	ETF	77.07	77.3	76.95	77.22	1147370.0
2009-03-16 08:00:00	SPY	ETF	77.22	77.25	75.66	76.99	4859420.0
2009-03-16 09:00:00	SPY	ETF	76.99	77.23	76.69	76.97	44146226.0
2009-03-16 10:00:00	SPY	ETF	76.97	77.31	76.55	76.88	52775321.0
2009-03-16 11:00:00	SPY	ETF	76.88	77.64	76.82	77.3	39481207.0
2009-03-16 12:00:00	SPY	ETF	77.3	77.96	77.13	77.92	30270722.0
2009-03-16 13:00:00	SPY	ETF	77.91	77.97	77.48	77.53	33929004.0
2009-03-16 14:00:00	SPY	ETF	77.54	77.57	76.83	76.9	48276773.0
2009-03-16 15:00:00	SPY	ETF	76.9	77.4	75.81	75.93	73875875.0
2009-03-16 16:00:00	SPY	ETF	75.94	77.92	75.86	76.21	10814794.0
2009-03-16 17:00:00	SPY	ETF	76.21	76.21	76.14	76.16	146608.0
2009-03-16 18:00:00	SPY	ETF	76.17	76.25	76.14	76.21	400041.0
2009-03-16 19:00:00	SPY	ETF	76.19	76.3	76.18	76.3	55816.0
2009-03-16 04:00:00	QQQ	ETF	28.91	28.94	28.91	28.94	2100.0
2009-03-16 05:00:00	QQQ	ETF	28.95	29.1	28.95	29.07	450.0
2009-03-16 06:00:00	QQQ	ETF	29.08	29.09	28.98	28.98	9300.0
2009-03-16 07:00:00	QQQ	ETF	28.99	29.07	28.97	29.07	312169.0
2009-03-16 08:00:00	QQQ	ETF	29.07	29.07	28.9	28.92	1162043.0
2009-03-16 09:00:00	QQQ	ETF	28.92	28.98	28.54	28.62	22367619.0
2009-03-16 10:00:00	QQQ	ETF	28.62	28.68	28.35	28.38	30919866.0
2009-03-16 11:00:00	QQQ	ETF	28.37	28.73	28.36	28.65	28952074.0
2009-03-16 12:00:00	QQQ	ETF	28.65	28.94	28.58	28.9199	18991967.0
2009-03-16 13:00:00	QQQ	ETF	28.91	28.93	28.64	28.67	15206708.0
2009-03-16 14:00:00	QQQ	ETF	28.67	28.72	28.5	28.53	19505092.0
2009-03-16 15:00:00	QQQ	ETF	28.53	28.55	28.19	28.24	32328736.0
2009-03-16 16:00:00	QQQ	ETF	28.24	28.7903	28.236	28.35	7650575.0
2009-03-16 17:00:00	QQQ	ETF	28.37	28.39	28.33	28.36	78915.0
2009-03-16 18:00:00	QQQ	ETF	28.36	28.39	28.34	28.36	28766.0
2009-03-16 19:00:00	QQQ	ETF	28.36	28.4	28.36	28.37	35448.0
2009-03-16 07:00:00	IWM	ETF	39.97	40.04	39.92	39.95	51400.0
2009-03-16 08:00:00	IWM	ETF	40.0	40.16	39.6	39.78	265269.0
2009-03-16 09:00:00	IWM	ETF	39.79	39.94	39.56	39.66	7555753.0
2009-03-16 10:00:00	IWM	ETF	39.67	39.77	39.355	39.511	8438584.0
2009-03-16 11:00:00	IWM	ETF	39.51	39.93	39.46	39.78	6817669.0
2009-03-16 12:00:00	IWM	ETF	39.79	40.15	39.71	40.11	4868664.0
2009-03-16 13:00:00	IWM	ETF	40.11	40.2	39.92	39.98	6391271.0
2009-03-16 14:00:00	IWM	ETF	39.98	40.0	39.48	39.54	9407358.0
2009-03-16 15:00:00	IWM	ETF	39.54	39.57	38.56	38.63	24697382.0
2009-03-16 16:00:00	IWM	ETF	38.63	40.0	38.6	38.99	7646345.0
2009-03-16 17:00:00	IWM	ETF	39.02	39.03	38.91	39.03	18299.0
2009-03-16 05:00:00	DIA	ETF	72.94	72.94	72.94	72.94	100.0
2009-03-16 07:00:00	DIA	ETF	73.17	73.27	72.99	73.2	27598.0
2009-03-16 08:00:00	DIA	ETF	73.2	73.22	72.9	72.9	66872.0
2009-03-16 09:00:00	DIA	ETF	72.93	73.27	72.83	73.03	2863977.0
2009-03-16 10:00:00	DIA	ETF	73.04	73.3	72.68	73.01	2950207.0
2009-03-16 11:00:00	DIA	ETF	73.0	73.61	72.96	73.38	2997757.0
2009-03-16 12:00:00	DIA	ETF	73.38	73.99	73.21	73.93	2396144.0

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

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