PREVIEW / etf_1hour / 2008-05-19

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-05-19.parquet
  size:    109 KB
  rows:    3,482

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
2008-05-19 04:00:00	SPY	ETF	142.6	142.63	142.5	142.5	32700.0
2008-05-19 05:00:00	SPY	ETF	142.47	142.69	142.47	142.69	22700.0
2008-05-19 06:00:00	SPY	ETF	142.74	142.79	142.69	142.73	6300.0
2008-05-19 07:00:00	SPY	ETF	142.72	142.76	142.61	142.69	700100.0
2008-05-19 08:00:00	SPY	ETF	142.71	142.81	142.5	142.74	955537.0
2008-05-19 09:00:00	SPY	ETF	142.74	143.09	142.49	143.06	18065459.0
2008-05-19 10:00:00	SPY	ETF	143.06	143.6	142.97	143.44	24065840.0
2008-05-19 11:00:00	SPY	ETF	143.44	144.07	143.38	143.91	22851141.0
2008-05-19 12:00:00	SPY	ETF	143.9	144.13	143.83	143.93	13844280.0
2008-05-19 13:00:00	SPY	ETF	143.93	144.3	143.65	143.68	15303477.0
2008-05-19 14:00:00	SPY	ETF	143.68	143.71	142.84	143.24	31579561.0
2008-05-19 15:00:00	SPY	ETF	143.24	143.34	142.3	142.83	31973335.0
2008-05-19 16:00:00	SPY	ETF	142.83	143.14	142.55	142.98	3627579.0
2008-05-19 17:00:00	SPY	ETF	142.99	143.05	142.98	143.0	721561.0
2008-05-19 18:00:00	SPY	ETF	143.02	143.04	142.98	142.98	29510.0
2008-05-19 19:00:00	SPY	ETF	143.0	143.04	142.97	143.04	6155.0
2008-05-19 04:00:00	QQQ	ETF	50.0	50.0	50.0	50.0	2000.0
2008-05-19 06:00:00	QQQ	ETF	50.02	50.03	50.0	50.0	7000.0
2008-05-19 07:00:00	QQQ	ETF	50.0	50.04	49.99	50.02	197937.0
2008-05-19 08:00:00	QQQ	ETF	50.01	50.09	49.99	50.07	257867.0
2008-05-19 09:00:00	QQQ	ETF	50.08	50.19	49.88	50.189	15470930.0
2008-05-19 10:00:00	QQQ	ETF	50.18	50.36	50.12	50.195	17455174.0
2008-05-19 11:00:00	QQQ	ETF	50.19	50.43	50.13	50.329	12854211.0
2008-05-19 12:00:00	QQQ	ETF	50.33	50.39	50.28	50.3099	6994234.0
2008-05-19 13:00:00	QQQ	ETF	50.31	50.47	50.08	50.09	10756834.0
2008-05-19 14:00:00	QQQ	ETF	50.09	50.1	49.6	49.8995	29263572.0
2008-05-19 15:00:00	QQQ	ETF	49.899	49.9	49.34	49.629	30582467.0
2008-05-19 16:00:00	QQQ	ETF	49.63	50.0	49.535	49.74	7325404.0
2008-05-19 17:00:00	QQQ	ETF	49.74	49.76	49.65	49.74	1614906.0
2008-05-19 18:00:00	QQQ	ETF	49.74	49.79	49.74	49.75	89543.0
2008-05-19 19:00:00	QQQ	ETF	49.76	49.76	49.7	49.7	35535.0
2008-05-19 07:00:00	IWM	ETF	73.88	73.93	73.88	73.92	73500.0
2008-05-19 08:00:00	IWM	ETF	73.9	73.99	73.9	73.96	97240.0
2008-05-19 09:00:00	IWM	ETF	73.96	74.03	73.48	73.86	6782326.0
2008-05-19 10:00:00	IWM	ETF	73.86	74.36	73.8	74.06	10724745.0
2008-05-19 11:00:00	IWM	ETF	74.06	74.63	73.95	74.51	10531820.0
2008-05-19 12:00:00	IWM	ETF	74.51	74.64	74.47	74.52	3039981.0
2008-05-19 13:00:00	IWM	ETF	74.52	74.74	74.2	74.21	8265306.0
2008-05-19 14:00:00	IWM	ETF	74.2	74.23	73.59	73.92	16890301.0
2008-05-19 15:00:00	IWM	ETF	73.92	74.04	73.47	73.62	17918255.0
2008-05-19 16:00:00	IWM	ETF	73.61	74.03	73.59	73.87	26805678.0
2008-05-19 17:00:00	IWM	ETF	73.9	73.9	73.89	73.89	710.0
2008-05-19 18:00:00	IWM	ETF	73.88	73.88	73.88	73.88	2600.0
2008-05-19 19:00:00	IWM	ETF	73.88	73.88	73.86	73.86	500.0
2008-05-19 06:00:00	DIA	ETF	129.68	129.68	129.68	129.68	100.0
2008-05-19 07:00:00	DIA	ETF	129.68	129.68	129.59	129.67	950.0
2008-05-19 08:00:00	DIA	ETF	129.66	129.74	129.65	129.7	7681.0
2008-05-19 09:00:00	DIA	ETF	129.68	129.98	129.51	129.95	765088.0
2008-05-19 10:00:00	DIA	ETF	129.94	130.36	129.87	130.21	1248355.0
2008-05-19 11:00:00	DIA	ETF	130.2	130.88	130.17	130.82	1827361.0

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

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