PREVIEW / etf_1hour / 2006-03-23

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-03-23.parquet
  size:    39 KB
  rows:    1,235

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
2006-03-23 07:00:00	SPY	ETF	130.19	130.28	130.18	130.28	33700.0
2006-03-23 08:00:00	SPY	ETF	130.29	130.3	130.19	130.27	436700.0
2006-03-23 09:00:00	SPY	ETF	130.27	130.34	130.16	130.27	3991900.0
2006-03-23 10:00:00	SPY	ETF	130.29	130.35	129.71	129.83	11701700.0
2006-03-23 11:00:00	SPY	ETF	129.83	130.3935	129.66	129.98	9805300.0
2006-03-23 12:00:00	SPY	ETF	129.99	130.23	129.84	130.11	3815600.0
2006-03-23 13:00:00	SPY	ETF	130.11	130.18	129.97	130.13	2968800.0
2006-03-23 14:00:00	SPY	ETF	130.15	130.21	129.67	129.84	4916400.0
2006-03-23 15:00:00	SPY	ETF	129.84	130.1	129.75	130.08	6253500.0
2006-03-23 16:00:00	SPY	ETF	130.08	130.2	130.0088	130.09	1029300.0
2006-03-23 17:00:00	SPY	ETF	130.08	130.21	129.95	129.96	374500.0
2006-03-23 18:00:00	SPY	ETF	129.96	130.04	129.93	130.0	120700.0
2006-03-23 19:00:00	SPY	ETF	129.94	130.0	129.94	130.0	6500.0
2006-03-23 09:00:00	QQQ	ETF	41.09	41.21	41.05	41.17	7124100.0
2006-03-23 10:00:00	QQQ	ETF	41.18	41.22	40.82	40.93	18182300.0
2006-03-23 11:00:00	QQQ	ETF	40.93	41.06	40.84	40.99	11281900.0
2006-03-23 12:00:00	QQQ	ETF	40.99	41.14	40.92	41.04	5691000.0
2006-03-23 13:00:00	QQQ	ETF	41.03	41.11	40.99	41.1	4193800.0
2006-03-23 14:00:00	QQQ	ETF	41.1	41.12	40.87	40.94	8113500.0
2006-03-23 15:00:00	QQQ	ETF	40.93	41.1	40.9	41.09	9156900.0
2006-03-23 07:00:00	IWM	ETF	74.0	74.0	74.0	74.0	100.0
2006-03-23 08:00:00	IWM	ETF	74.12	74.12	74.0	74.03	8800.0
2006-03-23 09:00:00	IWM	ETF	74.03	74.22	73.86	74.15	3203900.0
2006-03-23 10:00:00	IWM	ETF	74.15	74.27	73.75	73.94	3379200.0
2006-03-23 11:00:00	IWM	ETF	73.94	74.29	73.8	74.15	2641700.0
2006-03-23 12:00:00	IWM	ETF	74.14	74.34	74.03	74.24	2364000.0
2006-03-23 13:00:00	IWM	ETF	74.24	74.32	74.14	74.3	1624900.0
2006-03-23 14:00:00	IWM	ETF	74.3	74.36	73.93	74.01	4698200.0
2006-03-23 15:00:00	IWM	ETF	74.0	74.41	73.954	74.41	6632600.0
2006-03-23 16:00:00	IWM	ETF	74.41	74.47	74.4	74.43	282000.0
2006-03-23 17:00:00	IWM	ETF	74.45	74.47	74.45	74.47	3600.0
2006-03-23 18:00:00	IWM	ETF	74.43	74.44	74.43	74.43	24500.0
2006-03-23 19:00:00	IWM	ETF	74.44	74.44	74.43	74.43	24700.0
2006-03-23 07:00:00	DIA	ETF	112.96	112.98	112.95	112.98	800.0
2006-03-23 08:00:00	DIA	ETF	113.0	113.0	112.94	112.95	23200.0
2006-03-23 09:00:00	DIA	ETF	112.94	113.17	112.94	113.09	450300.0
2006-03-23 10:00:00	DIA	ETF	113.1	113.18	112.51	112.61	1539900.0
2006-03-23 11:00:00	DIA	ETF	112.6	112.72	112.44	112.62	858000.0
2006-03-23 12:00:00	DIA	ETF	112.63	112.87	112.53	112.75	494600.0
2006-03-23 13:00:00	DIA	ETF	112.75	112.8	112.58	112.67	395200.0
2006-03-23 14:00:00	DIA	ETF	112.67	112.74	112.25	112.37	1089400.0
2006-03-23 15:00:00	DIA	ETF	112.39	112.67	112.35	112.67	1066400.0
2006-03-23 16:00:00	DIA	ETF	112.68	112.79	112.68	112.79	15000.0
2006-03-23 17:00:00	DIA	ETF	112.76	112.9	112.76	112.76	3500.0
2006-03-23 18:00:00	DIA	ETF	112.76	112.76	112.72	112.72	800.0
2006-03-23 07:00:00	GLD	ETF	54.62	54.62	54.62	54.62	1000.0
2006-03-23 08:00:00	GLD	ETF	54.58	54.61	54.17	54.29	103800.0
2006-03-23 09:00:00	GLD	ETF	54.26	54.5	54.21	54.3974	711700.0
2006-03-23 10:00:00	GLD	ETF	54.4	54.5	54.27	54.42	1321100.0
2006-03-23 11:00:00	GLD	ETF	54.4054	54.7	54.384	54.64	785100.0

> showing 50 of 1,235 rows — these rows as CSV

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