PREVIEW / etf_30min / 2009-10-21

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-10-21.parquet
  size:    239 KB
  rows:    7,754

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-10-21 04:00:00	SPY	ETF	109.05	109.05	109.05	109.05	700.0
2009-10-21 04:30:00	SPY	ETF	109.0	109.25	109.0	109.25	500.0
2009-10-21 05:00:00	SPY	ETF	109.15	109.15	108.88	108.92	5169.0
2009-10-21 05:30:00	SPY	ETF	108.75	108.75	108.73	108.73	400.0
2009-10-21 06:00:00	SPY	ETF	108.87	108.9	108.68	108.8	47618.0
2009-10-21 06:30:00	SPY	ETF	108.87	108.91	108.84	108.84	6250.0
2009-10-21 07:00:00	SPY	ETF	108.86	108.86	108.75	108.81	257089.0
2009-10-21 07:30:00	SPY	ETF	108.78	108.81	108.56	108.77	522249.0
2009-10-21 08:00:00	SPY	ETF	108.77	109.05	108.67	109.02	2331924.0
2009-10-21 08:30:00	SPY	ETF	109.03	109.1	108.85	109.0	1563101.0
2009-10-21 09:00:00	SPY	ETF	109.0	109.05	108.95	109.04	718427.0
2009-10-21 09:30:00	SPY	ETF	109.04	109.89	108.99	109.74	25955323.0
2009-10-21 10:00:00	SPY	ETF	109.73	110.13	109.715	109.92	15436447.0
2009-10-21 10:30:00	SPY	ETF	109.93	110.31	109.82	110.02	16590276.0
2009-10-21 11:00:00	SPY	ETF	110.01	110.2	109.775	110.02	12704382.0
2009-10-21 11:30:00	SPY	ETF	110.02	110.035	109.63	109.73	9622329.0
2009-10-21 12:00:00	SPY	ETF	109.74	109.86	109.57	109.8	6892376.0
2009-10-21 12:30:00	SPY	ETF	109.79	109.94	109.73	109.88	5826757.0
2009-10-21 13:00:00	SPY	ETF	109.88	109.905	109.76	109.81	4199968.0
2009-10-21 13:30:00	SPY	ETF	109.82	110.02	109.68	109.98	7047383.0
2009-10-21 14:00:00	SPY	ETF	109.98	110.01	109.64	109.74	10436033.0
2009-10-21 14:30:00	SPY	ETF	109.74	109.92	109.57	109.86	8612272.0
2009-10-21 15:00:00	SPY	ETF	109.85	109.9	109.03	109.12	23812552.0
2009-10-21 15:30:00	SPY	ETF	109.12	109.12	108.15	108.25	55840865.0
2009-10-21 16:00:00	SPY	ETF	108.25	110.01	107.73	108.1	11801685.0
2009-10-21 16:30:00	SPY	ETF	108.1	108.2	108.06	108.16	1766152.0
2009-10-21 17:00:00	SPY	ETF	108.14	108.2	108.1	108.16	108130.0
2009-10-21 17:30:00	SPY	ETF	108.16	108.2	108.1	108.14	72485.0
2009-10-21 18:00:00	SPY	ETF	108.17	108.2	108.09	108.14	306945.0
2009-10-21 18:30:00	SPY	ETF	108.12	108.14	108.07	108.11	68983.0
2009-10-21 19:00:00	SPY	ETF	108.13	108.18	108.13	108.18	23948.0
2009-10-21 19:30:00	SPY	ETF	108.16	108.24	108.1	108.24	78205.0
2009-10-21 05:00:00	QQQ	ETF	43.14	43.14	43.11	43.11	8000.0
2009-10-21 05:30:00	QQQ	ETF	43.11	43.11	43.05	43.05	200.0
2009-10-21 06:00:00	QQQ	ETF	43.12	43.12	43.06	43.1	900.0
2009-10-21 06:30:00	QQQ	ETF	43.06	43.09	43.06	43.09	700.0
2009-10-21 07:00:00	QQQ	ETF	43.08	43.08	43.0	43.07	57405.0
2009-10-21 07:30:00	QQQ	ETF	43.05	43.1	43.0	43.08	133700.0
2009-10-21 08:00:00	QQQ	ETF	43.08	43.18	43.08	43.17	538644.0
2009-10-21 08:30:00	QQQ	ETF	43.17	43.19	43.11	43.15	179944.0
2009-10-21 09:00:00	QQQ	ETF	43.16	43.2	43.15	43.2	433117.0
2009-10-21 09:30:00	QQQ	ETF	43.2	43.58	43.16	43.52	15500067.0
2009-10-21 10:00:00	QQQ	ETF	43.53	43.73	43.51	43.66	10145154.0
2009-10-21 10:30:00	QQQ	ETF	43.66	43.82	43.5995	43.65	9469392.0
2009-10-21 11:00:00	QQQ	ETF	43.65	43.7	43.54	43.64	6114689.0
2009-10-21 11:30:00	QQQ	ETF	43.63	43.64	43.44	43.49	5069210.0
2009-10-21 12:00:00	QQQ	ETF	43.49	43.5499	43.42	43.5	2218516.0
2009-10-21 12:30:00	QQQ	ETF	43.51	43.6	43.48	43.56	3223059.0
2009-10-21 13:00:00	QQQ	ETF	43.56	43.62	43.52	43.56	2076299.0
2009-10-21 13:30:00	QQQ	ETF	43.57	43.7	43.49	43.68	4316276.0

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

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