PREVIEW / etf_30min / 2009-02-17

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-02-17.parquet
  size:    210 KB
  rows:    7,094

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-02-17 04:00:00	SPY	ETF	82.33	82.45	80.69	80.72	20776.0
2009-02-17 04:30:00	SPY	ETF	80.72	81.04	80.72	81.04	3200.0
2009-02-17 05:00:00	SPY	ETF	81.03	81.12	81.0	81.12	7289.0
2009-02-17 05:30:00	SPY	ETF	81.0	81.0	80.97	81.0	2100.0
2009-02-17 06:00:00	SPY	ETF	80.98	81.08	80.93	80.93	1600.0
2009-02-17 06:30:00	SPY	ETF	80.95	80.96	80.57	80.68	40600.0
2009-02-17 07:00:00	SPY	ETF	80.63	80.93	80.63	80.8	750523.0
2009-02-17 07:30:00	SPY	ETF	80.8	81.05	80.74	81.03	1218428.0
2009-02-17 08:00:00	SPY	ETF	80.82	81.14	80.65	80.82	2116684.0
2009-02-17 08:30:00	SPY	ETF	80.82	82.15	79.74	79.81	5566705.0
2009-02-17 09:00:00	SPY	ETF	79.83	80.2	79.76	80.16	5714322.0
2009-02-17 09:30:00	SPY	ETF	80.16	80.62	79.17	79.6601	59422247.0
2009-02-17 10:00:00	SPY	ETF	79.67	80.06	79.51	79.77	29725032.0
2009-02-17 10:30:00	SPY	ETF	79.77	80.24	79.64	80.05	32985553.0
2009-02-17 11:00:00	SPY	ETF	80.05	80.11	79.75	79.84	20828025.0
2009-02-17 11:30:00	SPY	ETF	79.84	79.85	79.4	79.55	21193093.0
2009-02-17 12:00:00	SPY	ETF	79.54	79.8	79.3	79.55	21239602.0
2009-02-17 12:30:00	SPY	ETF	79.56	79.98	79.5	79.76	15197833.0
2009-02-17 13:00:00	SPY	ETF	79.76	79.83	79.25	79.4	23881967.0
2009-02-17 13:30:00	SPY	ETF	79.3904	80.05	79.26	79.65	29196904.0
2009-02-17 14:00:00	SPY	ETF	79.6584	79.99	79.4666	79.6088	22369182.0
2009-02-17 14:30:00	SPY	ETF	79.61	80.17	79.5	79.66	28064711.0
2009-02-17 15:00:00	SPY	ETF	79.66	79.94	79.28	79.44	36791171.0
2009-02-17 15:30:00	SPY	ETF	79.45	82.958	79.17	79.22	72222388.0
2009-02-17 16:00:00	SPY	ETF	79.3	82.958	79.04	79.12	19853148.0
2009-02-17 16:30:00	SPY	ETF	79.12	79.22	79.05	79.09	1169033.0
2009-02-17 17:00:00	SPY	ETF	79.09	82.958	79.02	79.16	1319352.0
2009-02-17 17:30:00	SPY	ETF	79.19	79.28	79.17	79.27	278339.0
2009-02-17 18:00:00	SPY	ETF	79.27	79.28	79.11	79.17	336007.0
2009-02-17 18:30:00	SPY	ETF	79.12	79.18	79.07	79.1	16249.0
2009-02-17 19:00:00	SPY	ETF	79.12	79.25	79.12	79.19	19421.0
2009-02-17 19:30:00	SPY	ETF	79.21	79.38	79.21	79.35	14345.0
2009-02-17 04:00:00	QQQ	ETF	29.72	29.72	29.72	29.72	300.0
2009-02-17 04:30:00	QQQ	ETF	29.67	29.67	29.67	29.67	1100.0
2009-02-17 05:00:00	QQQ	ETF	29.64	29.64	29.64	29.64	200.0
2009-02-17 05:30:00	QQQ	ETF	29.62	29.65	29.62	29.62	1200.0
2009-02-17 06:00:00	QQQ	ETF	29.62	29.62	29.62	29.62	600.0
2009-02-17 06:30:00	QQQ	ETF	29.6	29.6	29.49	29.49	8500.0
2009-02-17 07:00:00	QQQ	ETF	29.51	29.6	29.51	29.59	224408.0
2009-02-17 07:30:00	QQQ	ETF	29.59	29.65	29.59	29.65	217794.0
2009-02-17 08:00:00	QQQ	ETF	29.65	29.76	29.59	29.63	1840837.0
2009-02-17 08:30:00	QQQ	ETF	29.63	29.67	29.4	29.43	958281.0
2009-02-17 09:00:00	QQQ	ETF	29.42	29.5	29.36	29.47	2643038.0
2009-02-17 09:30:00	QQQ	ETF	29.47	29.6	29.06	29.3	27456029.0
2009-02-17 10:00:00	QQQ	ETF	29.31	29.45	29.24	29.38	11486989.0
2009-02-17 10:30:00	QQQ	ETF	29.37	29.55	29.3	29.46	10883292.0
2009-02-17 11:00:00	QQQ	ETF	29.46	29.462	29.32	29.34	6972716.0
2009-02-17 11:30:00	QQQ	ETF	29.35	29.35	29.19	29.24	8684521.0
2009-02-17 12:00:00	QQQ	ETF	29.25	29.36	29.17	29.25	6894913.0
2009-02-17 12:30:00	QQQ	ETF	29.2578	29.32	29.22	29.3	3995120.0

> showing 50 of 7,094 rows — these rows as CSV

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