PREVIEW / etf_1hour / 2009-10-06

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-10-06.parquet
  size:    147 KB
  rows:    4,498

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-10-06 04:00:00	SPY	ETF	104.3	104.53	104.3	104.53	1300.0
2009-10-06 05:00:00	SPY	ETF	104.53	105.13	104.53	104.97	24049.0
2009-10-06 06:00:00	SPY	ETF	104.86	105.15	104.86	105.1	37710.0
2009-10-06 07:00:00	SPY	ETF	105.08	105.23	105.0	105.12	1153191.0
2009-10-06 08:00:00	SPY	ETF	105.1	105.13	104.02	104.91	2477364.0
2009-10-06 09:00:00	SPY	ETF	104.91	105.59	104.71	105.46	28594456.0
2009-10-06 10:00:00	SPY	ETF	105.47	105.75	105.37	105.6983	24368195.0
2009-10-06 11:00:00	SPY	ETF	105.69	106.11	105.64	105.771	23364825.0
2009-10-06 12:00:00	SPY	ETF	105.77	105.95	105.55	105.59	13967635.0
2009-10-06 13:00:00	SPY	ETF	105.59	105.64	105.1	105.26	22765615.0
2009-10-06 14:00:00	SPY	ETF	105.27	105.28	104.73	105.16	36260277.0
2009-10-06 15:00:00	SPY	ETF	105.1651	105.7	105.09	105.52	42326225.0
2009-10-06 16:00:00	SPY	ETF	105.5	105.998	104.0774	105.38	6756268.0
2009-10-06 17:00:00	SPY	ETF	105.4	105.4	105.33	105.36	112748.0
2009-10-06 18:00:00	SPY	ETF	105.37	105.4	105.34	105.39	36563.0
2009-10-06 19:00:00	SPY	ETF	105.4	105.45	105.4	105.45	24170.0
2009-10-06 05:00:00	QQQ	ETF	41.45	41.58	41.45	41.57	8200.0
2009-10-06 06:00:00	QQQ	ETF	41.5	41.57	41.5	41.56	6483.0
2009-10-06 07:00:00	QQQ	ETF	41.55	41.6	41.5	41.56	695197.0
2009-10-06 08:00:00	QQQ	ETF	41.55	41.57	41.45	41.47	1346932.0
2009-10-06 09:00:00	QQQ	ETF	41.47	41.85	41.41	41.8	19377849.0
2009-10-06 10:00:00	QQQ	ETF	41.81	42.02	41.8	41.95	17579102.0
2009-10-06 11:00:00	QQQ	ETF	41.95	42.14	41.9	41.98	13348359.0
2009-10-06 12:00:00	QQQ	ETF	41.97	42.085	41.95	41.96	5727485.0
2009-10-06 13:00:00	QQQ	ETF	41.9594	42.0	41.76	41.81	12376602.0
2009-10-06 14:00:00	QQQ	ETF	41.81	41.82	41.53	41.74	20988948.0
2009-10-06 15:00:00	QQQ	ETF	41.75	41.97	41.71	41.94	19454647.0
2009-10-06 16:00:00	QQQ	ETF	41.94	42.05	41.87	41.89	5788872.0
2009-10-06 17:00:00	QQQ	ETF	41.91	41.92	41.89	41.91	27384.0
2009-10-06 18:00:00	QQQ	ETF	41.91	41.95	41.9	41.92	109413.0
2009-10-06 19:00:00	QQQ	ETF	41.92	41.94	41.91	41.94	17490.0
2009-10-06 06:00:00	IWM	ETF	59.49	59.7	59.49	59.7	900.0
2009-10-06 07:00:00	IWM	ETF	59.78	59.86	59.7	59.83	40500.0
2009-10-06 08:00:00	IWM	ETF	59.79	59.79	58.96	59.64	439628.0
2009-10-06 09:00:00	IWM	ETF	59.65	60.14	59.36	60.04	10772967.0
2009-10-06 10:00:00	IWM	ETF	60.04	60.32	59.8	60.31	10171955.0
2009-10-06 11:00:00	IWM	ETF	60.3	60.445	60.15	60.1999	5665381.0
2009-10-06 12:00:00	IWM	ETF	60.2	60.415	60.13	60.14	2674330.0
2009-10-06 13:00:00	IWM	ETF	60.15	60.2	59.78	59.88	4463857.0
2009-10-06 14:00:00	IWM	ETF	59.87	59.88	59.45	59.812	8039564.0
2009-10-06 15:00:00	IWM	ETF	59.81	60.18	59.77	60.12	8803133.0
2009-10-06 16:00:00	IWM	ETF	60.12	60.22	60.05	60.06	925154.0
2009-10-06 17:00:00	IWM	ETF	60.08	60.09	60.06	60.06	2254.0
2009-10-06 18:00:00	IWM	ETF	60.05	60.1	60.05	60.05	2362.0
2009-10-06 05:00:00	DIA	ETF	96.71	96.71	96.71	96.71	100.0
2009-10-06 07:00:00	DIA	ETF	96.78	96.89	96.74	96.82	11400.0
2009-10-06 08:00:00	DIA	ETF	96.82	96.82	96.61	96.68	31672.0
2009-10-06 09:00:00	DIA	ETF	96.67	97.23	96.56	97.12	2553585.0
2009-10-06 10:00:00	DIA	ETF	97.13	97.41	97.05	97.34	1784937.0
2009-10-06 11:00:00	DIA	ETF	97.35	97.77	97.33	97.5	1536714.0

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

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