PREVIEW / etf_1hour / 2009-09-14

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-09-14.parquet
  size:    142 KB
  rows:    4,308

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-09-14 04:00:00	SPY	ETF	103.9	103.9	103.61	103.62	11505.0
2009-09-14 05:00:00	SPY	ETF	103.66	103.77	103.64	103.77	21400.0
2009-09-14 06:00:00	SPY	ETF	103.82	103.93	103.8	103.85	35100.0
2009-09-14 07:00:00	SPY	ETF	103.82	103.91	103.77	103.91	266207.0
2009-09-14 08:00:00	SPY	ETF	103.92	104.02	103.85	103.99	1352683.0
2009-09-14 09:00:00	SPY	ETF	103.99	104.43	103.5	104.37	19959027.0
2009-09-14 10:00:00	SPY	ETF	104.36	104.81	104.14	104.68	29478952.0
2009-09-14 11:00:00	SPY	ETF	104.68	104.9	104.54	104.58	13658175.0
2009-09-14 12:00:00	SPY	ETF	104.57	104.74	104.57	104.7	6881940.0
2009-09-14 13:00:00	SPY	ETF	104.7	104.89	104.56	104.8316	13111024.0
2009-09-14 14:00:00	SPY	ETF	104.83	105.25	103.15	105.18	23313694.0
2009-09-14 15:00:00	SPY	ETF	105.18	105.46	105.08	105.34	32135329.0
2009-09-14 16:00:00	SPY	ETF	105.33	105.4598	104.19	105.21	5510938.0
2009-09-14 17:00:00	SPY	ETF	105.22	105.22	105.14	105.2	3327927.0
2009-09-14 18:00:00	SPY	ETF	105.2	105.34	105.13	105.15	48298.0
2009-09-14 19:00:00	SPY	ETF	105.16	105.18	105.11	105.16	70003.0
2009-09-14 04:00:00	QQQ	ETF	41.11	41.11	41.11	41.11	928.0
2009-09-14 05:00:00	QQQ	ETF	41.1	41.17	41.09	41.17	40700.0
2009-09-14 06:00:00	QQQ	ETF	41.17	41.2	41.15	41.15	29100.0
2009-09-14 07:00:00	QQQ	ETF	41.16	41.21	41.1	41.21	84307.0
2009-09-14 08:00:00	QQQ	ETF	41.2	41.26	41.19	41.25	240771.0
2009-09-14 09:00:00	QQQ	ETF	41.25	41.45	41.2	41.44	12213070.0
2009-09-14 10:00:00	QQQ	ETF	41.45	41.57	41.35	41.521	11686795.0
2009-09-14 11:00:00	QQQ	ETF	41.524	41.6	41.42	41.44	9490714.0
2009-09-14 12:00:00	QQQ	ETF	41.4499	41.5667	41.43	41.53	3141247.0
2009-09-14 13:00:00	QQQ	ETF	41.53	41.59	41.44	41.54	7550307.0
2009-09-14 14:00:00	QQQ	ETF	41.55	41.68	41.51	41.65	10572519.0
2009-09-14 15:00:00	QQQ	ETF	41.65	41.71	41.56	41.68	13673865.0
2009-09-14 16:00:00	QQQ	ETF	41.68	41.7475	41.5032	41.57	16194473.0
2009-09-14 17:00:00	QQQ	ETF	41.58	41.6	41.5037	41.57	2222728.0
2009-09-14 18:00:00	QQQ	ETF	41.55	41.55	41.51	41.54	41297.0
2009-09-14 19:00:00	QQQ	ETF	41.54	41.55	41.53	41.54	91816.0
2009-09-14 07:00:00	IWM	ETF	58.81	58.87	58.81	58.87	3868.0
2009-09-14 08:00:00	IWM	ETF	58.93	58.95	58.8	58.88	325641.0
2009-09-14 09:00:00	IWM	ETF	58.88	59.39	58.81	59.33	6895197.0
2009-09-14 10:00:00	IWM	ETF	59.35	59.59	59.05	59.51	5609665.0
2009-09-14 11:00:00	IWM	ETF	59.52	59.79	59.47	59.56	4974838.0
2009-09-14 12:00:00	IWM	ETF	59.56	59.6899	59.53	59.68	1028613.0
2009-09-14 13:00:00	IWM	ETF	59.6794	59.82	59.57	59.75	3032373.0
2009-09-14 14:00:00	IWM	ETF	59.7488	60.03	59.685	59.9809	4177615.0
2009-09-14 15:00:00	IWM	ETF	59.98	60.11	59.84	60.04	8972658.0
2009-09-14 16:00:00	IWM	ETF	60.05	60.08	59.85	59.86	1480460.0
2009-09-14 17:00:00	IWM	ETF	59.89	59.9	59.86	59.9	13800.0
2009-09-14 18:00:00	IWM	ETF	59.93	59.95	59.89	59.89	1300.0
2009-09-14 19:00:00	IWM	ETF	59.89	59.96	59.88	59.88	5000.0
2009-09-14 07:00:00	DIA	ETF	95.37	95.43	95.37	95.43	2200.0
2009-09-14 08:00:00	DIA	ETF	95.54	95.55	95.43	95.52	23184.0
2009-09-14 09:00:00	DIA	ETF	95.52	95.9	95.4	95.82	955361.0
2009-09-14 10:00:00	DIA	ETF	95.82	96.22	95.66	96.12	2002247.0
2009-09-14 11:00:00	DIA	ETF	96.12	96.28	95.9106	95.94	995056.0

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

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