PREVIEW / etf_1hour / 2009-08-04

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-08-04.parquet
  size:    143 KB
  rows:    4,439

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-04 04:00:00	SPY	ETF	99.98	99.98	99.74	99.76	3839.0
2009-08-04 05:00:00	SPY	ETF	99.73	99.91	99.68	99.91	15860.0
2009-08-04 06:00:00	SPY	ETF	99.82	99.88	99.74	99.76	62794.0
2009-08-04 07:00:00	SPY	ETF	99.74	99.88	99.71	99.75	610076.0
2009-08-04 08:00:00	SPY	ETF	99.77	100.03	99.69	99.8	1493506.0
2009-08-04 09:00:00	SPY	ETF	99.81	100.18	99.78	100.18	19948077.0
2009-08-04 10:00:00	SPY	ETF	100.15	100.36	99.9	100.25	26597312.0
2009-08-04 11:00:00	SPY	ETF	100.245	100.62	100.24	100.53	17664945.0
2009-08-04 12:00:00	SPY	ETF	100.5291	100.84	100.25	100.8196	15162104.0
2009-08-04 13:00:00	SPY	ETF	100.81	100.84	100.21	100.26	19538288.0
2009-08-04 14:00:00	SPY	ETF	100.25	100.6	100.16	100.27	22909291.0
2009-08-04 15:00:00	SPY	ETF	100.2606	100.69	100.15	100.69	33105357.0
2009-08-04 16:00:00	SPY	ETF	100.69	100.95	99.921	100.92	19075043.0
2009-08-04 17:00:00	SPY	ETF	100.92	100.98	100.88	100.95	215246.0
2009-08-04 18:00:00	SPY	ETF	100.98	100.98	100.1601	100.94	70041.0
2009-08-04 19:00:00	SPY	ETF	100.93	100.95	100.9	100.92	64079.0
2009-08-04 04:00:00	QQQ	ETF	39.85	39.85	39.78	39.78	12947.0
2009-08-04 05:00:00	QQQ	ETF	39.78	39.79	39.78	39.79	5100.0
2009-08-04 06:00:00	QQQ	ETF	39.79	39.79	39.72	39.72	14903.0
2009-08-04 07:00:00	QQQ	ETF	39.74	39.79	39.73	39.76	152592.0
2009-08-04 08:00:00	QQQ	ETF	39.77	39.91	39.74	39.77	404066.0
2009-08-04 09:00:00	QQQ	ETF	39.79	39.94	39.77	39.89	11409673.0
2009-08-04 10:00:00	QQQ	ETF	39.89	40.01	39.83	39.93	17865532.0
2009-08-04 11:00:00	QQQ	ETF	39.93	40.09	39.91	40.05	8511214.0
2009-08-04 12:00:00	QQQ	ETF	40.06	40.14	40.01	40.14	6523266.0
2009-08-04 13:00:00	QQQ	ETF	40.14	40.19	39.85	39.8795	8444538.0
2009-08-04 14:00:00	QQQ	ETF	39.87	40.0	39.82	39.85	12690957.0
2009-08-04 15:00:00	QQQ	ETF	39.84	40.03	39.8	40.03	16543856.0
2009-08-04 16:00:00	QQQ	ETF	40.03	40.16	39.8157	40.15	12763607.0
2009-08-04 17:00:00	QQQ	ETF	40.14	40.16	40.14	40.16	83566.0
2009-08-04 18:00:00	QQQ	ETF	40.15	40.16	40.06	40.14	144838.0
2009-08-04 19:00:00	QQQ	ETF	40.15	40.15	40.13	40.15	69366.0
2009-08-04 06:00:00	IWM	ETF	56.01	56.02	56.01	56.02	3200.0
2009-08-04 07:00:00	IWM	ETF	55.99	56.07	55.99	56.02	33699.0
2009-08-04 08:00:00	IWM	ETF	56.03	56.19	56.01	56.07	158227.0
2009-08-04 09:00:00	IWM	ETF	56.13	56.46	56.12	56.41	3776306.0
2009-08-04 10:00:00	IWM	ETF	56.41	56.78	56.405	56.68	9588059.0
2009-08-04 11:00:00	IWM	ETF	56.67	57.02	56.67	56.9899	2980262.0
2009-08-04 12:00:00	IWM	ETF	56.98	57.29	56.92	57.28	3953192.0
2009-08-04 13:00:00	IWM	ETF	57.29	57.32	56.81	56.84	3129633.0
2009-08-04 14:00:00	IWM	ETF	56.84	57.15	56.78	56.95	4278594.0
2009-08-04 15:00:00	IWM	ETF	56.94	57.09	56.81	57.03	7433718.0
2009-08-04 16:00:00	IWM	ETF	57.03	57.26	57.01	57.26	3991449.0
2009-08-04 17:00:00	IWM	ETF	57.24	57.3	57.22	57.26	17350.0
2009-08-04 18:00:00	IWM	ETF	57.26	57.28	56.82	57.27	7978.0
2009-08-04 19:00:00	IWM	ETF	57.23	57.33	57.23	57.25	800.0
2009-08-04 04:00:00	DIA	ETF	92.55	92.55	92.5	92.5	200.0
2009-08-04 06:00:00	DIA	ETF	92.44	92.44	92.38	92.38	437.0
2009-08-04 07:00:00	DIA	ETF	92.4	92.44	92.37	92.41	5450.0
2009-08-04 08:00:00	DIA	ETF	92.41	92.51	92.34	92.42	48452.0

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

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