PREVIEW / etf_1hour / 2009-03-17

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-03-17.parquet
  size:    129 KB
  rows:    3,973

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-17 04:00:00	SPY	ETF	76.13	76.45	76.13	76.45	1100.0
2009-03-17 05:00:00	SPY	ETF	76.4	76.48	76.28	76.45	10200.0
2009-03-17 06:00:00	SPY	ETF	76.38	76.71	76.38	76.42	87900.0
2009-03-17 07:00:00	SPY	ETF	76.45	76.45	76.07	76.12	700406.0
2009-03-17 08:00:00	SPY	ETF	76.12	76.81	75.8	76.34	5378311.0
2009-03-17 09:00:00	SPY	ETF	76.34	76.36	75.45	75.89	33536372.0
2009-03-17 10:00:00	SPY	ETF	75.88	76.67	75.84	76.49	58291134.0
2009-03-17 11:00:00	SPY	ETF	76.48	76.49	75.85	76.44	27794316.0
2009-03-17 12:00:00	SPY	ETF	76.44	77.3	76.31	77.09	36310952.0
2009-03-17 13:00:00	SPY	ETF	77.09	77.52	76.91	76.9694	35463084.0
2009-03-17 14:00:00	SPY	ETF	76.97	77.45	75.8995	77.22	43948654.0
2009-03-17 15:00:00	SPY	ETF	77.22	78.3	77.12	78.26	78064765.0
2009-03-17 16:00:00	SPY	ETF	78.2	78.53	75.8995	78.41	14694358.0
2009-03-17 17:00:00	SPY	ETF	78.43	78.5	78.4	78.43	195141.0
2009-03-17 18:00:00	SPY	ETF	78.45	78.45	78.33	78.33	108519.0
2009-03-17 19:00:00	SPY	ETF	78.33	78.34	78.22	78.23	151820.0
2009-03-17 04:00:00	QQQ	ETF	28.47	28.48	28.47	28.48	400.0
2009-03-17 06:00:00	QQQ	ETF	28.48	28.61	28.48	28.55	5001.0
2009-03-17 07:00:00	QQQ	ETF	28.47	28.47	28.35	28.36	212582.0
2009-03-17 08:00:00	QQQ	ETF	28.36	28.52	28.27	28.46	736899.0
2009-03-17 09:00:00	QQQ	ETF	28.46	28.63	28.3	28.5099	20440531.0
2009-03-17 10:00:00	QQQ	ETF	28.51	28.7	28.45	28.6301	19212207.0
2009-03-17 11:00:00	QQQ	ETF	28.63	28.69	28.54	28.67	9919915.0
2009-03-17 12:00:00	QQQ	ETF	28.67	28.88	28.63	28.81	13778042.0
2009-03-17 13:00:00	QQQ	ETF	28.8	28.97	28.77	28.7821	15027495.0
2009-03-17 14:00:00	QQQ	ETF	28.79	28.98	28.67	28.9001	23468545.0
2009-03-17 15:00:00	QQQ	ETF	28.91	29.32	28.9	29.32	51869555.0
2009-03-17 16:00:00	QQQ	ETF	29.32	29.4	28.2227	29.37	8310124.0
2009-03-17 17:00:00	QQQ	ETF	29.36	29.38	29.34	29.37	94179.0
2009-03-17 18:00:00	QQQ	ETF	29.37	29.37	29.33	29.34	40116.0
2009-03-17 19:00:00	QQQ	ETF	29.34	29.35	29.32	29.33	42572.0
2009-03-17 06:00:00	IWM	ETF	39.23	39.23	39.19	39.19	200.0
2009-03-17 07:00:00	IWM	ETF	39.13	39.15	38.88	38.91	27095.0
2009-03-17 08:00:00	IWM	ETF	38.92	39.33	38.73	38.9	361281.0
2009-03-17 09:00:00	IWM	ETF	38.9	38.91	38.43	38.65	6865184.0
2009-03-17 10:00:00	IWM	ETF	38.65	39.26	38.645	39.18	11104572.0
2009-03-17 11:00:00	IWM	ETF	39.18	39.22	38.95	39.21	4534994.0
2009-03-17 12:00:00	IWM	ETF	39.21	39.71	39.2	39.55	4964537.0
2009-03-17 13:00:00	IWM	ETF	39.54	39.78	39.44	39.48	4127125.0
2009-03-17 14:00:00	IWM	ETF	39.48	39.75	39.28	39.65	6877315.0
2009-03-17 15:00:00	IWM	ETF	39.65	40.44	39.61	40.43	15176130.0
2009-03-17 16:00:00	IWM	ETF	40.44	40.76	38.7163	40.64	4526184.0
2009-03-17 17:00:00	IWM	ETF	40.62	40.65	40.61	40.65	47400.0
2009-03-17 18:00:00	IWM	ETF	40.65	40.65	40.64	40.64	800.0
2009-03-17 19:00:00	IWM	ETF	40.56	40.57	40.56	40.57	375.0
2009-03-17 06:00:00	DIA	ETF	72.9	72.92	72.8	72.8	600.0
2009-03-17 07:00:00	DIA	ETF	72.58	72.6	72.34	72.39	10900.0
2009-03-17 08:00:00	DIA	ETF	72.37	72.75	72.15	72.64	49167.0
2009-03-17 09:00:00	DIA	ETF	72.65	72.65	71.86	72.14	2229088.0
2009-03-17 10:00:00	DIA	ETF	72.13	72.7	71.96	72.56	4180486.0

> showing 50 of 3,973 rows — these rows as CSV

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