PREVIEW / etf_1hour / 2009-03-12

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-03-12.parquet
  size:    132 KB
  rows:    4,044

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-12 04:00:00	SPY	ETF	72.3	72.47	71.98	72.0	7500.0
2009-03-12 05:00:00	SPY	ETF	72.07	72.07	72.06	72.06	6000.0
2009-03-12 06:00:00	SPY	ETF	71.9	71.9	71.7	71.81	95150.0
2009-03-12 07:00:00	SPY	ETF	71.82	72.09	71.72	72.06	634319.0
2009-03-12 08:00:00	SPY	ETF	72.06	72.68	71.86	72.5	5811352.0
2009-03-12 09:00:00	SPY	ETF	72.49	72.81	71.97	72.51	42612526.0
2009-03-12 10:00:00	SPY	ETF	72.51	74.02	72.48	73.72	68081523.0
2009-03-12 11:00:00	SPY	ETF	73.72	73.92	73.33	73.6901	42265354.0
2009-03-12 12:00:00	SPY	ETF	73.7	74.41	73.68	74.37	42426196.0
2009-03-12 13:00:00	SPY	ETF	74.37	74.58	74.1	74.4525	37889571.0
2009-03-12 14:00:00	SPY	ETF	74.44	75.29	72.95	75.04	56150059.0
2009-03-12 15:00:00	SPY	ETF	75.0301	75.75	72.6444	75.51	76217501.0
2009-03-12 16:00:00	SPY	ETF	75.51	75.8	73.5365	75.51	23579432.0
2009-03-12 17:00:00	SPY	ETF	75.51	75.57	72.6445	75.47	11389192.0
2009-03-12 18:00:00	SPY	ETF	75.49	75.5	75.39	75.4	120175.0
2009-03-12 19:00:00	SPY	ETF	75.42	75.48	75.37	75.48	74092.0
2009-03-12 04:00:00	QQQ	ETF	27.66	27.69	27.49	27.49	6520.0
2009-03-12 05:00:00	QQQ	ETF	27.55	27.55	27.54	27.54	324.0
2009-03-12 06:00:00	QQQ	ETF	27.51	27.51	27.44	27.5	2900.0
2009-03-12 07:00:00	QQQ	ETF	27.46	27.5	27.41	27.49	61000.0
2009-03-12 08:00:00	QQQ	ETF	27.49	27.72	27.47	27.67	739506.0
2009-03-12 09:00:00	QQQ	ETF	27.67	27.77	27.44	27.59	20402221.0
2009-03-12 10:00:00	QQQ	ETF	27.6	28.11	27.58	28.04	24307677.0
2009-03-12 11:00:00	QQQ	ETF	28.03	28.2	27.89	28.1398	19204610.0
2009-03-12 12:00:00	QQQ	ETF	28.14	28.35	28.12	28.32	13864217.0
2009-03-12 13:00:00	QQQ	ETF	28.32	28.38	28.24	28.3017	17121161.0
2009-03-12 14:00:00	QQQ	ETF	28.31	28.62	28.23	28.51	22666710.0
2009-03-12 15:00:00	QQQ	ETF	28.51	28.76	28.45	28.67	35557447.0
2009-03-12 16:00:00	QQQ	ETF	28.67	28.78	27.7438	28.68	21528629.0
2009-03-12 17:00:00	QQQ	ETF	28.68	28.73	28.0	28.73	157418.0
2009-03-12 18:00:00	QQQ	ETF	28.72	28.72	28.65	28.67	106226.0
2009-03-12 19:00:00	QQQ	ETF	28.67	28.71	28.62	28.71	68280.0
2009-03-12 07:00:00	IWM	ETF	36.19	36.25	36.17	36.25	30653.0
2009-03-12 08:00:00	IWM	ETF	36.184	36.6	36.184	36.52	164370.0
2009-03-12 09:00:00	IWM	ETF	36.52	36.71	36.07	36.43	6209577.0
2009-03-12 10:00:00	IWM	ETF	36.42	37.62	36.39	37.51	15040505.0
2009-03-12 11:00:00	IWM	ETF	37.5	37.8	37.32	37.65	7778669.0
2009-03-12 12:00:00	IWM	ETF	37.65	38.04	37.64	38.0189	5568271.0
2009-03-12 13:00:00	IWM	ETF	38.02	38.2	37.88	38.12	5733791.0
2009-03-12 14:00:00	IWM	ETF	38.12	39.01	37.5	38.79	19454970.0
2009-03-12 15:00:00	IWM	ETF	38.79	39.19	38.64	38.95	21265619.0
2009-03-12 16:00:00	IWM	ETF	38.95	39.33	38.85	39.12	3433225.0
2009-03-12 17:00:00	IWM	ETF	39.13	39.15	37.41	39.06	37997.0
2009-03-12 18:00:00	IWM	ETF	39.07	39.07	39.0	39.0	1100.0
2009-03-12 04:00:00	DIA	ETF	68.93	68.93	68.93	68.93	200.0
2009-03-12 06:00:00	DIA	ETF	68.75	68.75	68.7	68.7	300.0
2009-03-12 07:00:00	DIA	ETF	68.59	68.87	68.54	68.85	3950.0
2009-03-12 08:00:00	DIA	ETF	68.87	69.45	68.86	69.34	55959.0
2009-03-12 09:00:00	DIA	ETF	69.32	69.53	68.85	69.3	2399013.0
2009-03-12 10:00:00	DIA	ETF	69.3	70.65	69.29	70.4	3593494.0

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

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