PREVIEW / etf_1hour / 2009-05-07

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-05-07.parquet
  size:    140 KB
  rows:    4,334

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-05-07 04:00:00	SPY	ETF	92.33	92.49	92.29	92.49	8100.0
2009-05-07 05:00:00	SPY	ETF	92.53	92.7	92.43	92.7	6300.0
2009-05-07 06:00:00	SPY	ETF	92.7	92.81	92.61	92.69	78461.0
2009-05-07 07:00:00	SPY	ETF	92.71	92.85	92.58	92.83	1172666.0
2009-05-07 08:00:00	SPY	ETF	92.83	93.47	92.05	92.88	6745442.0
2009-05-07 09:00:00	SPY	ETF	92.88	93.15	92.32	92.43	37710947.0
2009-05-07 10:00:00	SPY	ETF	92.44	93.1	91.33	91.74	58635457.0
2009-05-07 11:00:00	SPY	ETF	91.74	92.15	91.12	91.62	31332162.0
2009-05-07 12:00:00	SPY	ETF	91.62	91.74	91.31	91.581	15800600.0
2009-05-07 13:00:00	SPY	ETF	91.59	91.64	90.59	90.88	38456708.0
2009-05-07 14:00:00	SPY	ETF	90.88	91.03	90.35	90.58	32248640.0
2009-05-07 15:00:00	SPY	ETF	90.57	91.11	90.28	90.84	69203437.0
2009-05-07 16:00:00	SPY	ETF	90.85	92.1224	90.7285	90.97	20625704.0
2009-05-07 17:00:00	SPY	ETF	90.96	91.8	90.94	91.64	3145917.0
2009-05-07 18:00:00	SPY	ETF	91.6	91.77	90.68	91.6	198354.0
2009-05-07 19:00:00	SPY	ETF	91.63	91.68	90.6801	91.6	48204.0
2009-05-07 05:00:00	QQQ	ETF	35.18	35.19	35.14	35.19	17684.0
2009-05-07 06:00:00	QQQ	ETF	35.23	35.28	35.23	35.26	16502.0
2009-05-07 07:00:00	QQQ	ETF	35.26	35.27	35.17	35.24	220730.0
2009-05-07 08:00:00	QQQ	ETF	35.23	35.39	35.0	35.22	3157162.0
2009-05-07 09:00:00	QQQ	ETF	35.22	35.28	34.58	34.5999	23092384.0
2009-05-07 10:00:00	QQQ	ETF	34.59	34.65	34.2	34.35	38991265.0
2009-05-07 11:00:00	QQQ	ETF	34.36	34.43	34.13	34.36	28286734.0
2009-05-07 12:00:00	QQQ	ETF	34.36	34.38	34.22	34.349	10217593.0
2009-05-07 13:00:00	QQQ	ETF	34.35	34.36	34.0	34.061	24284023.0
2009-05-07 14:00:00	QQQ	ETF	34.06	34.12	33.9	34.03	19034928.0
2009-05-07 15:00:00	QQQ	ETF	34.03	34.29	33.88	34.18	35075679.0
2009-05-07 16:00:00	QQQ	ETF	34.18	35.0306	34.1107	34.24	13717918.0
2009-05-07 17:00:00	QQQ	ETF	34.29	35.0305	34.16	34.35	2118585.0
2009-05-07 18:00:00	QQQ	ETF	34.38	34.43	34.36	34.37	165474.0
2009-05-07 19:00:00	QQQ	ETF	34.37	34.41	34.36	34.39	98105.0
2009-05-07 06:00:00	IWM	ETF	51.09	51.1	51.05	51.05	2600.0
2009-05-07 07:00:00	IWM	ETF	50.99	51.16	50.93	51.12	52500.0
2009-05-07 08:00:00	IWM	ETF	51.1	51.41	50.6	51.24	920746.0
2009-05-07 09:00:00	IWM	ETF	51.23	51.4	50.57	50.67	6466015.0
2009-05-07 10:00:00	IWM	ETF	50.65	50.76	49.75	49.97	9253807.0
2009-05-07 11:00:00	IWM	ETF	49.99	50.05	49.52	49.98	7024502.0
2009-05-07 12:00:00	IWM	ETF	49.97	50.09	49.77	50.0	5528190.0
2009-05-07 13:00:00	IWM	ETF	50.0	50.06	49.08	49.22	10706042.0
2009-05-07 14:00:00	IWM	ETF	49.23	49.26	48.89	49.05	9735692.0
2009-05-07 15:00:00	IWM	ETF	49.05	49.5	48.89	49.28	13512440.0
2009-05-07 16:00:00	IWM	ETF	49.29	49.57	49.165	49.35	1511297.0
2009-05-07 17:00:00	IWM	ETF	49.52	49.77	49.52	49.7	55700.0
2009-05-07 18:00:00	IWM	ETF	49.75	49.78	49.7	49.7	5100.0
2009-05-07 19:00:00	IWM	ETF	49.64	49.73	49.55	49.73	2000.0
2009-05-07 06:00:00	DIA	ETF	85.75	85.82	85.67	85.75	10315.0
2009-05-07 07:00:00	DIA	ETF	85.77	85.85	85.71	85.85	11041.0
2009-05-07 08:00:00	DIA	ETF	85.79	86.15	85.77	85.87	252696.0
2009-05-07 09:00:00	DIA	ETF	85.81	85.96	85.21	85.27	2698828.0
2009-05-07 10:00:00	DIA	ETF	85.26	85.36	84.28	84.66	3597755.0

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

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