PREVIEW / etf_1hour / 2005-04-19

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-04-19.parquet
  size:    30 KB
  rows:    878

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
2005-04-19 04:00:00	SPY	ETF	114.72	114.72	114.71	114.71	2000.0
2005-04-19 07:00:00	SPY	ETF	114.84	115.04	114.8	114.91	212500.0
2005-04-19 08:00:00	SPY	ETF	114.9	115.12	114.78	115.02	897000.0
2005-04-19 09:00:00	SPY	ETF	115.03	115.27	115.0	115.25	11927500.0
2005-04-19 10:00:00	SPY	ETF	115.26	115.33	114.83	114.98	13579000.0
2005-04-19 11:00:00	SPY	ETF	114.98	115.32	114.93	115.26	6473400.0
2005-04-19 12:00:00	SPY	ETF	115.26	115.3	114.99	115.15	5455600.0
2005-04-19 13:00:00	SPY	ETF	115.15	115.49	114.95	115.42	7049200.0
2005-04-19 14:00:00	SPY	ETF	115.43	115.53	115.24	115.41	6294100.0
2005-04-19 15:00:00	SPY	ETF	115.41	115.45	115.11	115.3	9260900.0
2005-04-19 16:00:00	SPY	ETF	115.3085	115.89	115.03	115.8	5530700.0
2005-04-19 17:00:00	SPY	ETF	115.75	115.78	115.73	115.76	125500.0
2005-04-19 18:00:00	SPY	ETF	115.75	115.76	115.69	115.76	32500.0
2005-04-19 19:00:00	SPY	ETF	115.74	115.8	115.74	115.8	4900.0
2005-04-19 09:00:00	QQQ	ETF	35.02	35.05	34.9	35.01	15963200.0
2005-04-19 10:00:00	QQQ	ETF	35.02	35.04	34.75	34.84	15573300.0
2005-04-19 11:00:00	QQQ	ETF	34.84	35.02	34.82	34.99	9364900.0
2005-04-19 12:00:00	QQQ	ETF	34.98	35.0	34.86	34.94	7207900.0
2005-04-19 13:00:00	QQQ	ETF	34.94	35.1	34.91	35.07	11723000.0
2005-04-19 14:00:00	QQQ	ETF	35.07	35.08	34.97	35.01	8038300.0
2005-04-19 15:00:00	QQQ	ETF	35.01	35.08	34.95	34.99	16151600.0
2005-04-19 07:00:00	IWM	ETF	58.45	58.55	58.45	58.49	68800.0
2005-04-19 08:00:00	IWM	ETF	58.47	58.625	58.39	58.58	545600.0
2005-04-19 09:00:00	IWM	ETF	58.58	58.84	58.48	58.84	8383000.0
2005-04-19 10:00:00	IWM	ETF	58.85	58.94	58.57	58.63	5530000.0
2005-04-19 11:00:00	IWM	ETF	58.625	58.825	58.625	58.765	4098000.0
2005-04-19 12:00:00	IWM	ETF	58.77	58.82	58.67	58.745	2307200.0
2005-04-19 13:00:00	IWM	ETF	58.76	59.0	58.625	58.985	2787400.0
2005-04-19 14:00:00	IWM	ETF	58.98	59.025	58.86	58.93	3501200.0
2005-04-19 15:00:00	IWM	ETF	58.935	59.115	58.83	59.05	3966200.0
2005-04-19 16:00:00	IWM	ETF	59.035	59.415	59.025	59.375	598600.0
2005-04-19 17:00:00	IWM	ETF	59.405	59.415	59.36	59.36	34400.0
2005-04-19 18:00:00	IWM	ETF	59.35	59.375	59.34	59.375	16000.0
2005-04-19 07:00:00	DIA	ETF	100.95	101.0	100.95	101.0	32100.0
2005-04-19 08:00:00	DIA	ETF	100.95	101.04	100.85	100.95	40100.0
2005-04-19 09:00:00	DIA	ETF	100.95	101.21	100.94	101.14	1789700.0
2005-04-19 10:00:00	DIA	ETF	101.16	101.2	100.8	100.93	889200.0
2005-04-19 11:00:00	DIA	ETF	100.93	101.29	100.88	101.23	693100.0
2005-04-19 12:00:00	DIA	ETF	101.24	101.26	101.07	101.18	847700.0
2005-04-19 13:00:00	DIA	ETF	101.17	101.41	101.04	101.39	668000.0
2005-04-19 14:00:00	DIA	ETF	101.39	101.5	101.25	101.31	929300.0
2005-04-19 15:00:00	DIA	ETF	101.3	101.34	101.05	101.18	1459500.0
2005-04-19 16:00:00	DIA	ETF	101.19	101.59	101.18	101.58	223300.0
2005-04-19 17:00:00	DIA	ETF	101.58	101.65	101.58	101.65	3000.0
2005-04-19 08:00:00	GLD	ETF	42.75	42.75	42.75	42.75	1000.0
2005-04-19 09:00:00	GLD	ETF	42.79	42.79	42.72	42.76	49600.0
2005-04-19 10:00:00	GLD	ETF	42.74	43.23	42.72	43.17	241700.0
2005-04-19 11:00:00	GLD	ETF	43.17	43.25	43.14	43.25	523400.0
2005-04-19 12:00:00	GLD	ETF	43.25	43.3	43.2	43.29	159500.0
2005-04-19 13:00:00	GLD	ETF	43.26	43.29	43.23	43.25	47000.0

> showing 50 of 878 rows — these rows as CSV

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