PREVIEW / etf_1hour / 2009-08-17

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-08-17.parquet
  size:    144 KB
  rows:    4,547

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-08-17 04:00:00	SPY	ETF	99.14	99.32	98.76	98.89	19360.0
2009-08-17 05:00:00	SPY	ETF	99.02	99.09	98.74	99.09	77006.0
2009-08-17 06:00:00	SPY	ETF	99.16	99.19	98.78	98.82	81445.0
2009-08-17 07:00:00	SPY	ETF	98.84	98.93	98.54	98.67	1822039.0
2009-08-17 08:00:00	SPY	ETF	98.66	100.5	98.66	99.06	3681618.0
2009-08-17 09:00:00	SPY	ETF	99.07	100.79	98.22	98.54	32954519.0
2009-08-17 10:00:00	SPY	ETF	98.55	98.62	98.3	98.4	30683660.0
2009-08-17 11:00:00	SPY	ETF	98.4	98.8386	98.17	98.69	30298509.0
2009-08-17 12:00:00	SPY	ETF	98.69	98.73	98.51	98.57	11813504.0
2009-08-17 13:00:00	SPY	ETF	98.58	98.905	98.34	98.626	22279511.0
2009-08-17 14:00:00	SPY	ETF	98.63	98.65	98.37	98.46	17353434.0
2009-08-17 15:00:00	SPY	ETF	98.46	98.91	98.115	98.23	51467949.0
2009-08-17 16:00:00	SPY	ETF	98.24	100.6942	98.02	98.27	18502932.0
2009-08-17 17:00:00	SPY	ETF	98.27	98.42	98.12	98.14	1250020.0
2009-08-17 18:00:00	SPY	ETF	98.15	98.455	98.14	98.24	155648.0
2009-08-17 19:00:00	SPY	ETF	98.22	98.36	98.17	98.35	44595.0
2009-08-17 04:00:00	QQQ	ETF	38.97	39.11	38.97	39.01	16580.0
2009-08-17 05:00:00	QQQ	ETF	39.0	39.08	38.98	39.08	441.0
2009-08-17 06:00:00	QQQ	ETF	39.08	39.1	39.01	39.02	30417.0
2009-08-17 07:00:00	QQQ	ETF	39.04	39.07	38.93	38.94	836992.0
2009-08-17 08:00:00	QQQ	ETF	38.97	39.5	38.94	39.11	1266792.0
2009-08-17 09:00:00	QQQ	ETF	39.11	39.15	38.66	38.87	24411247.0
2009-08-17 10:00:00	QQQ	ETF	38.87	38.88	38.66	38.69	18749987.0
2009-08-17 11:00:00	QQQ	ETF	38.69	38.76	38.55	38.7099	11187107.0
2009-08-17 12:00:00	QQQ	ETF	38.7096	38.72	38.64	38.67	6325745.0
2009-08-17 13:00:00	QQQ	ETF	38.66	38.68	38.54	38.67	11346262.0
2009-08-17 14:00:00	QQQ	ETF	38.67	38.67	38.54	38.57	9570557.0
2009-08-17 15:00:00	QQQ	ETF	38.58	38.64	38.46	38.48	28009479.0
2009-08-17 16:00:00	QQQ	ETF	38.48	39.6563	38.44	38.59	14707377.0
2009-08-17 17:00:00	QQQ	ETF	38.56	38.59	38.5	38.55	59428.0
2009-08-17 18:00:00	QQQ	ETF	38.53	38.54	38.51	38.53	56579.0
2009-08-17 19:00:00	QQQ	ETF	38.53	38.58	38.52	38.58	50298.0
2009-08-17 04:00:00	IWM	ETF	55.9	55.9	55.9	55.9	1001.0
2009-08-17 05:00:00	IWM	ETF	54.89	55.43	54.89	55.43	1200.0
2009-08-17 06:00:00	IWM	ETF	55.55	55.55	55.3	55.32	11800.0
2009-08-17 07:00:00	IWM	ETF	55.36	55.43	55.18	55.2	101819.0
2009-08-17 08:00:00	IWM	ETF	55.21	55.88	55.18	55.45	1045578.0
2009-08-17 09:00:00	IWM	ETF	55.45	55.53	54.7	54.9	11004058.0
2009-08-17 10:00:00	IWM	ETF	54.9	54.975	54.698	54.85	5502115.0
2009-08-17 11:00:00	IWM	ETF	54.84	55.08	54.68	55.0	4147654.0
2009-08-17 12:00:00	IWM	ETF	54.9999	55.06	54.84	55.01	2687142.0
2009-08-17 13:00:00	IWM	ETF	55.01	55.05	54.88	55.0099	2651831.0
2009-08-17 14:00:00	IWM	ETF	55.0	55.08	54.88	54.98	3100048.0
2009-08-17 15:00:00	IWM	ETF	54.98	55.05	54.76	54.84	11459755.0
2009-08-17 16:00:00	IWM	ETF	54.79	56.425	54.72	54.94	5161629.0
2009-08-17 17:00:00	IWM	ETF	54.91	54.99	54.79	54.85	125524.0
2009-08-17 18:00:00	IWM	ETF	54.81	54.82	54.73	54.73	2900.0
2009-08-17 19:00:00	IWM	ETF	54.75	54.8	54.68	54.72	3800.0
2009-08-17 05:00:00	DIA	ETF	92.03	92.03	91.92	92.02	400.0
2009-08-17 06:00:00	DIA	ETF	92.05	92.08	91.82	91.87	600.0

> showing 50 of 4,547 rows — these rows as CSV

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