PREVIEW / etf_1hour / 2006-03-22

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-03-22.parquet
  size:    40 KB
  rows:    1,245

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-22 04:00:00	SPY	ETF	129.62	129.62	129.62	129.62	300.0
2006-03-22 06:00:00	SPY	ETF	129.68	129.68	129.68	129.68	3000.0
2006-03-22 07:00:00	SPY	ETF	129.68	129.7	129.51	129.53	106900.0
2006-03-22 08:00:00	SPY	ETF	129.55	129.69	129.48	129.62	453200.0
2006-03-22 09:00:00	SPY	ETF	129.62	129.76	129.45	129.72	7957600.0
2006-03-22 10:00:00	SPY	ETF	129.71	130.1	129.69	129.75	8487200.0
2006-03-22 11:00:00	SPY	ETF	129.75	130.19	129.74	130.11	6678500.0
2006-03-22 12:00:00	SPY	ETF	130.11	130.25	130.03	130.14	4702000.0
2006-03-22 13:00:00	SPY	ETF	130.14	130.33	130.11	130.25	4102600.0
2006-03-22 14:00:00	SPY	ETF	130.24	130.31	129.92	130.13	5850400.0
2006-03-22 15:00:00	SPY	ETF	130.16	130.51	130.05	130.4	6609400.0
2006-03-22 16:00:00	SPY	ETF	130.4	130.43	130.32	130.37	4358300.0
2006-03-22 17:00:00	SPY	ETF	130.37	130.4	130.34	130.34	53900.0
2006-03-22 18:00:00	SPY	ETF	130.4	130.43	130.4	130.42	5900.0
2006-03-22 19:00:00	SPY	ETF	130.42	130.43	130.42	130.43	600.0
2006-03-22 09:00:00	QQQ	ETF	40.88	41.08	40.86	41.0	15179200.0
2006-03-22 10:00:00	QQQ	ETF	41.0	41.21	40.93	40.93	24268800.0
2006-03-22 11:00:00	QQQ	ETF	40.93	41.18	40.93	41.12	18741900.0
2006-03-22 12:00:00	QQQ	ETF	41.12	41.21	41.12	41.16	8730400.0
2006-03-22 13:00:00	QQQ	ETF	41.17	41.25	41.14	41.19	8926300.0
2006-03-22 14:00:00	QQQ	ETF	41.18	41.22	41.0	41.11	8410700.0
2006-03-22 15:00:00	QQQ	ETF	41.11	41.28	41.01	41.21	17872700.0
2006-03-22 07:00:00	IWM	ETF	73.05	73.05	72.95	72.98	12100.0
2006-03-22 08:00:00	IWM	ETF	72.98	73.05	72.95	73.05	97300.0
2006-03-22 09:00:00	IWM	ETF	73.05	73.27	72.86	73.03	4709900.0
2006-03-22 10:00:00	IWM	ETF	73.02	73.51	73.0	73.18	6189800.0
2006-03-22 11:00:00	IWM	ETF	73.18	73.66	73.18	73.62	3048300.0
2006-03-22 12:00:00	IWM	ETF	73.62	73.79	73.59	73.71	3407200.0
2006-03-22 13:00:00	IWM	ETF	73.71	73.99	73.69	73.94	4129000.0
2006-03-22 14:00:00	IWM	ETF	73.94	73.98	73.71	73.86	3459900.0
2006-03-22 15:00:00	IWM	ETF	73.84	74.22	73.71	74.11	8502200.0
2006-03-22 16:00:00	IWM	ETF	74.11	74.16	73.99	74.16	328600.0
2006-03-22 17:00:00	IWM	ETF	74.14	74.15	74.06	74.06	4600.0
2006-03-22 18:00:00	IWM	ETF	74.11	74.11	74.09	74.11	2500.0
2006-03-22 19:00:00	IWM	ETF	74.13	74.13	74.13	74.13	200.0
2006-03-22 08:00:00	DIA	ETF	112.29	112.43	112.29	112.4	182600.0
2006-03-22 09:00:00	DIA	ETF	112.4	112.6	112.27	112.6	800000.0
2006-03-22 10:00:00	DIA	ETF	112.6	112.82	112.5	112.51	1286400.0
2006-03-22 11:00:00	DIA	ETF	112.53	112.91	112.53	112.84	1123700.0
2006-03-22 12:00:00	DIA	ETF	112.84	112.93	112.77	112.84	497500.0
2006-03-22 13:00:00	DIA	ETF	112.8412	112.99	112.82	112.94	453400.0
2006-03-22 14:00:00	DIA	ETF	112.93	113.0	112.72	112.89	1064000.0
2006-03-22 15:00:00	DIA	ETF	112.89	113.19	112.84	113.04	1288500.0
2006-03-22 16:00:00	DIA	ETF	113.02	113.1	113.01	113.1	43800.0
2006-03-22 17:00:00	DIA	ETF	113.1	113.1	113.1	113.1	100.0
2006-03-22 07:00:00	GLD	ETF	54.75	54.75	54.55	54.55	4600.0
2006-03-22 08:00:00	GLD	ETF	54.55	54.8	54.5	54.76	8400.0
2006-03-22 09:00:00	GLD	ETF	54.65	54.79	54.62	54.7	181500.0
2006-03-22 10:00:00	GLD	ETF	54.72	54.83	54.6	54.67	247000.0
2006-03-22 11:00:00	GLD	ETF	54.6624	54.8315	54.61	54.73	160700.0

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

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