PREVIEW / etf_1hour / 2009-08-12

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-08-12.parquet
  size:    139 KB
  rows:    4,284

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-12 04:00:00	SPY	ETF	99.37	99.47	99.27	99.47	28079.0
2009-08-12 05:00:00	SPY	ETF	99.57	99.57	99.43	99.57	700.0
2009-08-12 06:00:00	SPY	ETF	99.67	99.93	99.67	99.86	8800.0
2009-08-12 07:00:00	SPY	ETF	99.86	99.89	99.48	99.56	568581.0
2009-08-12 08:00:00	SPY	ETF	99.56	99.91	99.55	99.6	1755688.0
2009-08-12 09:00:00	SPY	ETF	99.61	100.59	99.51	100.57	24892909.0
2009-08-12 10:00:00	SPY	ETF	100.57	101.09	100.57	100.9625	42789157.0
2009-08-12 11:00:00	SPY	ETF	100.97	101.06	100.86	101.02	16448149.0
2009-08-12 12:00:00	SPY	ETF	101.02	101.09	100.8	101.02	13471144.0
2009-08-12 13:00:00	SPY	ETF	101.02	101.2	100.92	101.028	19710357.0
2009-08-12 14:00:00	SPY	ETF	101.03	101.45	100.49	101.44	42436485.0
2009-08-12 15:00:00	SPY	ETF	101.43	101.56	100.65	100.78	43381260.0
2009-08-12 16:00:00	SPY	ETF	100.77	100.9898	99.6927	100.84	11263399.0
2009-08-12 17:00:00	SPY	ETF	100.84	100.91	99.6927	100.89	1295830.0
2009-08-12 18:00:00	SPY	ETF	100.89	100.91	100.75	100.75	179225.0
2009-08-12 19:00:00	SPY	ETF	100.78	100.86	100.73	100.86	105073.0
2009-08-12 04:00:00	QQQ	ETF	39.17	39.17	39.17	39.17	100.0
2009-08-12 06:00:00	QQQ	ETF	39.37	39.39	39.37	39.39	9337.0
2009-08-12 07:00:00	QQQ	ETF	39.4	39.41	39.27	39.28	42703.0
2009-08-12 08:00:00	QQQ	ETF	39.3	39.43	39.15	39.26	611893.0
2009-08-12 09:00:00	QQQ	ETF	39.27	39.85	39.19	39.82	17481882.0
2009-08-12 10:00:00	QQQ	ETF	39.83	39.97	39.79	39.96	23016892.0
2009-08-12 11:00:00	QQQ	ETF	39.96	40.0	39.91	39.95	10719999.0
2009-08-12 12:00:00	QQQ	ETF	39.94	39.98	39.87	39.94	5559688.0
2009-08-12 13:00:00	QQQ	ETF	39.94	40.01	39.87	39.8801	9414555.0
2009-08-12 14:00:00	QQQ	ETF	39.89	40.13	39.72	40.13	22674948.0
2009-08-12 15:00:00	QQQ	ETF	40.12	40.22	39.81	39.87	37080803.0
2009-08-12 16:00:00	QQQ	ETF	39.87	40.15	39.2385	39.91	10815059.0
2009-08-12 17:00:00	QQQ	ETF	39.9	39.94	39.9	39.93	225629.0
2009-08-12 18:00:00	QQQ	ETF	39.92	39.93	39.85	39.9	55657.0
2009-08-12 19:00:00	QQQ	ETF	39.89	39.92	39.88	39.88	5900.0
2009-08-12 06:00:00	IWM	ETF	56.49	56.49	56.49	56.49	420.0
2009-08-12 07:00:00	IWM	ETF	56.47	56.48	56.24	56.31	102495.0
2009-08-12 08:00:00	IWM	ETF	56.4	56.55	56.3	56.33	212581.0
2009-08-12 09:00:00	IWM	ETF	56.32	57.15	56.25	57.07	5578687.0
2009-08-12 10:00:00	IWM	ETF	57.07	57.45	57.0422	57.4	5923857.0
2009-08-12 11:00:00	IWM	ETF	57.39	57.5	57.34	57.44	2459023.0
2009-08-12 12:00:00	IWM	ETF	57.445	57.53	57.34	57.48	1982663.0
2009-08-12 13:00:00	IWM	ETF	57.49	57.61	57.41	57.47	3357373.0
2009-08-12 14:00:00	IWM	ETF	57.48	57.77	57.18	57.76	9212611.0
2009-08-12 15:00:00	IWM	ETF	57.75	57.84	57.11	57.16	15254333.0
2009-08-12 16:00:00	IWM	ETF	57.16	57.47	56.2366	57.24	7237124.0
2009-08-12 17:00:00	IWM	ETF	57.27	57.29	57.13	57.2	1844180.0
2009-08-12 18:00:00	IWM	ETF	57.25	57.25	57.23	57.24	5800.0
2009-08-12 19:00:00	IWM	ETF	57.27	57.57	57.23	57.57	2040.0
2009-08-12 07:00:00	DIA	ETF	92.82	92.82	92.49	92.51	36250.0
2009-08-12 08:00:00	DIA	ETF	92.54	92.82	92.51	92.62	66344.0
2009-08-12 09:00:00	DIA	ETF	92.61	93.46	92.5	93.46	1403940.0
2009-08-12 10:00:00	DIA	ETF	93.45	93.96	93.45	93.85	2474377.0
2009-08-12 11:00:00	DIA	ETF	93.85	93.93	93.77	93.87	820403.0

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

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