PREVIEW / etf_1hour / 2009-08-31

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-08-31.parquet
  size:    141 KB
  rows:    4,349

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-31 04:00:00	SPY	ETF	102.43	102.68	102.38	102.67	39195.0
2009-08-31 05:00:00	SPY	ETF	102.69	102.79	102.61	102.61	1900.0
2009-08-31 06:00:00	SPY	ETF	102.58	102.71	102.47	102.53	25698.0
2009-08-31 07:00:00	SPY	ETF	102.52	102.69	102.5	102.55	374083.0
2009-08-31 08:00:00	SPY	ETF	103.5	103.5	102.41	102.57	1551742.0
2009-08-31 09:00:00	SPY	ETF	102.56	103.38	101.79	102.0799	34280647.0
2009-08-31 10:00:00	SPY	ETF	102.07	102.41	101.88	102.29	29094755.0
2009-08-31 11:00:00	SPY	ETF	102.29	102.3	102.01	102.15	11782625.0
2009-08-31 12:00:00	SPY	ETF	102.1599	102.25	101.91	102.02	11106112.0
2009-08-31 13:00:00	SPY	ETF	102.02	102.13	101.92	102.09	10032276.0
2009-08-31 14:00:00	SPY	ETF	102.09	102.42	102.0	102.28	14337342.0
2009-08-31 15:00:00	SPY	ETF	102.28	102.58	101.95	102.48	40728189.0
2009-08-31 16:00:00	SPY	ETF	102.51	102.6	102.1333	102.52	10346501.0
2009-08-31 17:00:00	SPY	ETF	102.48	103.27	102.47	102.57	1127200.0
2009-08-31 18:00:00	SPY	ETF	102.52	102.59	102.52	102.57	72104.0
2009-08-31 19:00:00	SPY	ETF	102.55	102.57	102.48	102.5	59265.0
2009-08-31 04:00:00	QQQ	ETF	40.08	40.08	40.04	40.04	1920.0
2009-08-31 05:00:00	QQQ	ETF	40.14	40.14	40.13	40.13	700.0
2009-08-31 06:00:00	QQQ	ETF	40.14	40.2	40.13	40.19	4320.0
2009-08-31 07:00:00	QQQ	ETF	40.17	40.18	40.14	40.15	14800.0
2009-08-31 08:00:00	QQQ	ETF	40.15	40.16	40.06	40.1	837954.0
2009-08-31 09:00:00	QQQ	ETF	40.1	40.2	39.79	39.88	16793944.0
2009-08-31 10:00:00	QQQ	ETF	39.87	40.05	39.79	39.97	17980684.0
2009-08-31 11:00:00	QQQ	ETF	39.98	39.98	39.82	39.9	7028053.0
2009-08-31 12:00:00	QQQ	ETF	39.9	39.95	39.84	39.85	6944805.0
2009-08-31 13:00:00	QQQ	ETF	39.8599	39.88	39.81	39.86	4244892.0
2009-08-31 14:00:00	QQQ	ETF	39.87	40.0	39.82	39.93	8386478.0
2009-08-31 15:00:00	QQQ	ETF	39.93	40.04	39.82	40.03	19327519.0
2009-08-31 16:00:00	QQQ	ETF	40.03	40.05	39.9	40.0	7355720.0
2009-08-31 17:00:00	QQQ	ETF	39.99	40.0	39.98	40.0	95791.0
2009-08-31 18:00:00	QQQ	ETF	40.0	40.03	40.0	40.01	36838.0
2009-08-31 19:00:00	QQQ	ETF	40.0	40.03	40.0	40.03	40898.0
2009-08-31 04:00:00	IWM	ETF	57.6	57.6	57.6	57.6	1400.0
2009-08-31 06:00:00	IWM	ETF	57.62	57.65	57.62	57.65	2792.0
2009-08-31 07:00:00	IWM	ETF	57.61	57.63	57.56	57.59	31400.0
2009-08-31 08:00:00	IWM	ETF	57.59	57.59	57.45	57.51	91262.0
2009-08-31 09:00:00	IWM	ETF	57.5	57.62	56.98	57.17	5513863.0
2009-08-31 10:00:00	IWM	ETF	57.17	57.38	57.0	57.32	5362121.0
2009-08-31 11:00:00	IWM	ETF	57.34	57.34	57.02	57.07	3428135.0
2009-08-31 12:00:00	IWM	ETF	57.07	57.16	57.0	57.04	2390754.0
2009-08-31 13:00:00	IWM	ETF	57.03	57.08	56.93	57.05	2343739.0
2009-08-31 14:00:00	IWM	ETF	57.05	57.27	56.97	57.18	1725065.0
2009-08-31 15:00:00	IWM	ETF	57.18	57.36	57.01	57.21	7212165.0
2009-08-31 16:00:00	IWM	ETF	57.21	58.0504	57.1368	57.32	6683426.0
2009-08-31 17:00:00	IWM	ETF	57.32	57.33	57.28	57.28	11100.0
2009-08-31 18:00:00	IWM	ETF	57.29	57.29	57.29	57.29	200.0
2009-08-31 19:00:00	IWM	ETF	57.3	57.78	57.27	57.28	14300.0
2009-08-31 06:00:00	DIA	ETF	94.9	94.9	94.9	94.9	400.0
2009-08-31 07:00:00	DIA	ETF	94.87	94.9	94.87	94.9	1400.0
2009-08-31 08:00:00	DIA	ETF	94.9	94.97	94.76	94.9	437176.0

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

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