PREVIEW / etf_1hour / 2009-02-26

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-02-26.parquet
  size:    126 KB
  rows:    3,854

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-02-26 04:00:00	SPY	ETF	77.54	77.68	77.36	77.36	1900.0
2009-02-26 05:00:00	SPY	ETF	77.3	77.3	76.94	76.94	300.0
2009-02-26 06:00:00	SPY	ETF	77.14	77.82	77.07	77.51	675110.0
2009-02-26 07:00:00	SPY	ETF	77.49	78.22	77.42	78.09	1217223.0
2009-02-26 08:00:00	SPY	ETF	78.23	78.23	77.3	77.83	5845042.0
2009-02-26 09:00:00	SPY	ETF	77.82	78.03	77.31	77.78	34129849.0
2009-02-26 10:00:00	SPY	ETF	77.78	78.375	77.48	78.22	56943006.0
2009-02-26 11:00:00	SPY	ETF	78.22	78.28	77.25	77.54	36891245.0
2009-02-26 12:00:00	SPY	ETF	77.54	77.72	76.92	77.15	31969858.0
2009-02-26 13:00:00	SPY	ETF	77.15	77.3	76.53	77.13	37591687.0
2009-02-26 14:00:00	SPY	ETF	77.13	77.24	76.01	76.18	45287207.0
2009-02-26 15:00:00	SPY	ETF	76.19	79.6667	75.53	75.67	91937954.0
2009-02-26 16:00:00	SPY	ETF	75.67	76.8905	75.49	75.71	15101426.0
2009-02-26 17:00:00	SPY	ETF	75.7	75.76	75.5	75.6	414736.0
2009-02-26 18:00:00	SPY	ETF	75.6	75.73	75.57	75.71	156220.0
2009-02-26 19:00:00	SPY	ETF	75.73	75.76	75.5	75.74	88815.0
2009-02-26 04:00:00	QQQ	ETF	28.78	28.84	28.67	28.67	2000.0
2009-02-26 05:00:00	QQQ	ETF	28.71	28.71	28.6	28.6	1200.0
2009-02-26 06:00:00	QQQ	ETF	28.63	28.85	28.63	28.84	20100.0
2009-02-26 07:00:00	QQQ	ETF	28.7	28.9	28.7	28.86	48700.0
2009-02-26 08:00:00	QQQ	ETF	28.85	28.85	28.66	28.79	924642.0
2009-02-26 09:00:00	QQQ	ETF	28.77	28.83	28.42	28.61	23130866.0
2009-02-26 10:00:00	QQQ	ETF	28.6	28.95	28.54	28.88	24574916.0
2009-02-26 11:00:00	QQQ	ETF	28.89	28.91	28.42	28.61	19871116.0
2009-02-26 12:00:00	QQQ	ETF	28.61	28.67	28.36	28.4	15559456.0
2009-02-26 13:00:00	QQQ	ETF	28.4	28.44	28.18	28.3501	17953831.0
2009-02-26 14:00:00	QQQ	ETF	28.35	28.38	27.91	28.0	27627795.0
2009-02-26 15:00:00	QQQ	ETF	28.0	28.05	27.77	27.8	54706343.0
2009-02-26 16:00:00	QQQ	ETF	27.81	27.9	27.78	27.86	18600425.0
2009-02-26 17:00:00	QQQ	ETF	27.86	27.88	27.75	27.76	307159.0
2009-02-26 18:00:00	QQQ	ETF	27.8	27.84	27.78	27.83	140260.0
2009-02-26 19:00:00	QQQ	ETF	27.83	27.83	27.77	27.82	39229.0
2009-02-26 04:00:00	IWM	ETF	40.26	40.26	40.26	40.26	100.0
2009-02-26 06:00:00	IWM	ETF	40.48	40.48	40.38	40.42	20254.0
2009-02-26 07:00:00	IWM	ETF	40.37	40.73	40.36	40.67	43068.0
2009-02-26 08:00:00	IWM	ETF	40.66	40.69	40.26	40.58	271847.0
2009-02-26 09:00:00	IWM	ETF	40.53	40.63	40.09	40.37	5980508.0
2009-02-26 10:00:00	IWM	ETF	40.38	40.75	40.22	40.67	9706782.0
2009-02-26 11:00:00	IWM	ETF	40.66	40.71	40.18	40.37	6441026.0
2009-02-26 12:00:00	IWM	ETF	40.37	40.44	40.04	40.14	5950557.0
2009-02-26 13:00:00	IWM	ETF	40.14	40.24	39.86	40.08	5957592.0
2009-02-26 14:00:00	IWM	ETF	40.082	40.14	39.48	39.58	8709373.0
2009-02-26 15:00:00	IWM	ETF	39.57	39.73	39.21	39.44	21831877.0
2009-02-26 16:00:00	IWM	ETF	39.44	40.7	39.4	39.49	1945464.0
2009-02-26 17:00:00	IWM	ETF	39.45	39.49	39.45	39.45	1001.0
2009-02-26 19:00:00	IWM	ETF	39.42	39.42	39.34	39.34	400.0
2009-02-26 04:00:00	DIA	ETF	73.2	73.2	73.2	73.2	100.0
2009-02-26 06:00:00	DIA	ETF	73.32	73.32	73.32	73.32	440.0
2009-02-26 07:00:00	DIA	ETF	73.35	73.69	73.35	73.6	29904.0
2009-02-26 08:00:00	DIA	ETF	73.62	73.62	73.1	73.39	72533.0

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

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