PREVIEW / etf_1hour / 2009-05-01

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-05-01.parquet
  size:    131 KB
  rows:    4,024

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-05-01 04:00:00	SPY	ETF	87.7	87.73	87.7	87.73	1100.0
2009-05-01 05:00:00	SPY	ETF	87.78	87.84	87.72	87.78	33850.0
2009-05-01 06:00:00	SPY	ETF	87.78	87.9	87.75	87.89	53836.0
2009-05-01 07:00:00	SPY	ETF	87.86	87.94	87.8	87.86	455511.0
2009-05-01 08:00:00	SPY	ETF	87.86	87.9	87.25	87.73	2311226.0
2009-05-01 09:00:00	SPY	ETF	87.73	87.73	86.94	87.36	25913393.0
2009-05-01 10:00:00	SPY	ETF	87.3601	87.5	86.72	87.16	34959702.0
2009-05-01 11:00:00	SPY	ETF	87.17	87.75	87.14	87.37	28213843.0
2009-05-01 12:00:00	SPY	ETF	87.36	87.72	87.26	87.59	20857332.0
2009-05-01 13:00:00	SPY	ETF	87.6	88.21	87.51	87.89	22732488.0
2009-05-01 14:00:00	SPY	ETF	87.89	88.06	87.61	87.68	20314996.0
2009-05-01 15:00:00	SPY	ETF	87.68	87.91	87.13	87.86	50921454.0
2009-05-01 16:00:00	SPY	ETF	87.84	88.27	87.5122	88.09	13780474.0
2009-05-01 17:00:00	SPY	ETF	88.07	88.07	87.99	88.02	124369.0
2009-05-01 18:00:00	SPY	ETF	88.03	88.2	86.7306	88.07	422501.0
2009-05-01 19:00:00	SPY	ETF	88.1	88.17	88.05	88.16	28088.0
2009-05-01 04:00:00	QQQ	ETF	34.42	34.46	34.42	34.46	1900.0
2009-05-01 05:00:00	QQQ	ETF	34.43	34.43	34.43	34.43	100.0
2009-05-01 06:00:00	QQQ	ETF	34.43	34.43	34.43	34.43	1000.0
2009-05-01 07:00:00	QQQ	ETF	34.46	34.5	34.43	34.44	199946.0
2009-05-01 08:00:00	QQQ	ETF	34.43	34.45	34.33	34.35	1186117.0
2009-05-01 09:00:00	QQQ	ETF	34.34	34.35	34.08	34.21	10512070.0
2009-05-01 10:00:00	QQQ	ETF	34.21	34.28	34.01	34.17	17368767.0
2009-05-01 11:00:00	QQQ	ETF	34.17	34.34	34.15	34.1601	8942180.0
2009-05-01 12:00:00	QQQ	ETF	34.16	34.38	34.14	34.345	7496359.0
2009-05-01 13:00:00	QQQ	ETF	34.34	34.54	34.31	34.44	9898585.0
2009-05-01 14:00:00	QQQ	ETF	34.44	34.5	34.27	34.28	13097651.0
2009-05-01 15:00:00	QQQ	ETF	34.285	34.41	34.11	34.35	22923130.0
2009-05-01 16:00:00	QQQ	ETF	34.35	34.51	34.1653	34.45	4374022.0
2009-05-01 17:00:00	QQQ	ETF	34.44	34.45	34.43	34.44	16161.0
2009-05-01 18:00:00	QQQ	ETF	34.43	34.47	34.43	34.45	14734.0
2009-05-01 19:00:00	QQQ	ETF	34.45	34.47	34.43	34.47	31037.0
2009-05-01 06:00:00	IWM	ETF	48.86	49.02	48.86	49.02	15500.0
2009-05-01 07:00:00	IWM	ETF	48.94	49.13	48.94	48.94	57900.0
2009-05-01 08:00:00	IWM	ETF	48.94	49.0	48.74	48.74	1425657.0
2009-05-01 09:00:00	IWM	ETF	48.73	48.915	48.43	48.83	7413641.0
2009-05-01 10:00:00	IWM	ETF	48.84	49.03	48.43	48.74	6999884.0
2009-05-01 11:00:00	IWM	ETF	48.74	49.12	48.68	48.74	6667501.0
2009-05-01 12:00:00	IWM	ETF	48.73	49.06	48.66	48.972	3777960.0
2009-05-01 13:00:00	IWM	ETF	48.98	49.3	48.52	49.03	5100538.0
2009-05-01 14:00:00	IWM	ETF	49.03	49.1	48.46	48.81	6171588.0
2009-05-01 15:00:00	IWM	ETF	48.81	49.04	48.41	48.82	15595798.0
2009-05-01 16:00:00	IWM	ETF	48.82	48.99	48.52	48.81	4305463.0
2009-05-01 17:00:00	IWM	ETF	48.8	48.8	48.77	48.78	2300.0
2009-05-01 18:00:00	IWM	ETF	48.86	48.86	48.85	48.85	440.0
2009-05-01 19:00:00	IWM	ETF	48.87	48.89	48.87	48.89	2000.0
2009-05-01 06:00:00	DIA	ETF	82.0	82.12	82.0	82.12	300.0
2009-05-01 07:00:00	DIA	ETF	82.11	82.15	82.11	82.12	3900.0
2009-05-01 08:00:00	DIA	ETF	82.1	82.13	81.97	81.99	15440.0
2009-05-01 09:00:00	DIA	ETF	81.85	81.85	81.23	81.55	1836191.0

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

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