PREVIEW / etf_1hour / 2009-03-30

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-03-30.parquet
  size:    131 KB
  rows:    4,072

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-03-30 04:00:00	SPY	ETF	79.6	80.35	79.6	79.8	12184.0
2009-03-30 05:00:00	SPY	ETF	79.9	80.04	79.84	80.0	90280.0
2009-03-30 06:00:00	SPY	ETF	80.13	80.22	79.96	80.19	159511.0
2009-03-30 07:00:00	SPY	ETF	80.19	80.34	80.04	80.06	1104686.0
2009-03-30 08:00:00	SPY	ETF	80.06	81.3817	79.35	80.0	3322454.0
2009-03-30 09:00:00	SPY	ETF	80.0	80.04	79.03	79.3	48345286.0
2009-03-30 10:00:00	SPY	ETF	79.3	79.44	78.6	78.8	49498589.0
2009-03-30 11:00:00	SPY	ETF	78.79	79.08	78.41	78.76	36402209.0
2009-03-30 12:00:00	SPY	ETF	78.76	79.04	78.61	78.65	24380247.0
2009-03-30 13:00:00	SPY	ETF	78.65	78.88	78.25	78.29	27635474.0
2009-03-30 14:00:00	SPY	ETF	78.29	78.73	77.96	77.99	41500426.0
2009-03-30 15:00:00	SPY	ETF	77.99	78.94	77.96	78.8	79495317.0
2009-03-30 16:00:00	SPY	ETF	78.78	79.5	78.67	79.02	9560703.0
2009-03-30 17:00:00	SPY	ETF	79.05	79.05	78.83	78.95	178654.0
2009-03-30 18:00:00	SPY	ETF	78.91	79.15	78.91	79.15	109049.0
2009-03-30 19:00:00	SPY	ETF	79.13	79.26	79.06	79.26	118843.0
2009-03-30 04:00:00	QQQ	ETF	30.08	30.14	30.08	30.14	1691.0
2009-03-30 05:00:00	QQQ	ETF	30.1	30.1	30.09	30.09	300.0
2009-03-30 06:00:00	QQQ	ETF	30.2	30.26	30.2	30.23	2700.0
2009-03-30 07:00:00	QQQ	ETF	30.28	30.36	30.27	30.3	217589.0
2009-03-30 08:00:00	QQQ	ETF	30.32	30.4	30.25	30.35	1124796.0
2009-03-30 09:00:00	QQQ	ETF	30.35	30.38	29.86	30.0	30110518.0
2009-03-30 10:00:00	QQQ	ETF	30.0	30.03	29.63	29.76	27806337.0
2009-03-30 11:00:00	QQQ	ETF	29.76	29.83	29.62	29.81	17653242.0
2009-03-30 12:00:00	QQQ	ETF	29.81	29.955	29.74	29.819	10394762.0
2009-03-30 13:00:00	QQQ	ETF	29.819	29.88	29.67	29.76	12995845.0
2009-03-30 14:00:00	QQQ	ETF	29.76	29.91	29.65	29.67	17107168.0
2009-03-30 15:00:00	QQQ	ETF	29.66	30.07	29.65	30.03	26148574.0
2009-03-30 16:00:00	QQQ	ETF	30.04	30.15	29.85	30.13	11329560.0
2009-03-30 17:00:00	QQQ	ETF	30.12	30.15	30.08	30.09	71930.0
2009-03-30 18:00:00	QQQ	ETF	30.1	30.17	30.1	30.17	74828.0
2009-03-30 19:00:00	QQQ	ETF	30.17	30.25	30.17	30.24	73255.0
2009-03-30 06:00:00	IWM	ETF	42.08	42.1	42.0	42.0	9400.0
2009-03-30 07:00:00	IWM	ETF	42.04	42.13	42.04	42.06	8543.0
2009-03-30 08:00:00	IWM	ETF	42.04	42.13	41.6	41.99	329607.0
2009-03-30 09:00:00	IWM	ETF	41.98	41.98	40.94	41.19	8054959.0
2009-03-30 10:00:00	IWM	ETF	41.19	41.42	40.7801	41.05	7460625.0
2009-03-30 11:00:00	IWM	ETF	41.05	41.34	40.87	41.2475	5550385.0
2009-03-30 12:00:00	IWM	ETF	41.25	41.67	41.23	41.42	5047818.0
2009-03-30 13:00:00	IWM	ETF	41.42	41.64	41.2	41.23	5881037.0
2009-03-30 14:00:00	IWM	ETF	41.23	41.58	41.16	41.22	6624527.0
2009-03-30 15:00:00	IWM	ETF	41.21	41.81	41.17	41.68	16809736.0
2009-03-30 16:00:00	IWM	ETF	41.68	41.75	41.51	41.75	1705419.0
2009-03-30 17:00:00	IWM	ETF	41.65	41.67	41.61	41.62	16523.0
2009-03-30 18:00:00	IWM	ETF	42.875	42.875	42.875	42.875	1000205.0
2009-03-30 19:00:00	IWM	ETF	41.75	41.75	41.75	41.75	200.0
2009-03-30 04:00:00	DIA	ETF	76.5	76.5	76.5	76.5	250.0
2009-03-30 06:00:00	DIA	ETF	76.41	76.46	76.41	76.46	3500.0
2009-03-30 07:00:00	DIA	ETF	76.51	76.55	76.41	76.41	15090.0
2009-03-30 08:00:00	DIA	ETF	76.44	76.57	76.31	76.31	134689.0

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

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