PREVIEW / etf_30min / 2007-11-02

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-11-02.parquet
  size:    139 KB
  rows:    5,151

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
2007-11-02 04:00:00	SPY	ETF	151.01	151.01	151.01	151.01	100.0
2007-11-02 05:00:00	SPY	ETF	151.06	151.11	151.06	151.11	3500.0
2007-11-02 06:30:00	SPY	ETF	150.82	150.94	150.79	150.81	24900.0
2007-11-02 07:00:00	SPY	ETF	150.8	150.8	150.33	150.34	734800.0
2007-11-02 07:30:00	SPY	ETF	150.38	150.98	150.36	150.87	870500.0
2007-11-02 08:00:00	SPY	ETF	151.17	151.17	150.42	150.89	2920000.0
2007-11-02 08:30:00	SPY	ETF	150.72	152.0	150.56	151.77	17315800.0
2007-11-02 09:00:00	SPY	ETF	151.76	151.95	151.54	151.54	2977350.0
2007-11-02 09:30:00	SPY	ETF	151.53	151.56	149.6	150.06	61886840.0
2007-11-02 10:00:00	SPY	ETF	150.05	150.28	149.39	150.23	30386709.0
2007-11-02 10:30:00	SPY	ETF	150.23	150.5	149.81	150.25	24924681.0
2007-11-02 11:00:00	SPY	ETF	150.26	150.5	149.31	149.41	16702522.0
2007-11-02 11:30:00	SPY	ETF	149.41	150.31	149.21	149.96	24082772.0
2007-11-02 12:00:00	SPY	ETF	149.97	150.45	149.82	150.37	14746523.0
2007-11-02 12:30:00	SPY	ETF	150.37	151.14	150.24	150.96	25150735.0
2007-11-02 13:00:00	SPY	ETF	150.96	152.0	150.39	150.54	19453438.0
2007-11-02 13:30:00	SPY	ETF	150.54	150.75	150.3	150.56	9579756.0
2007-11-02 14:00:00	SPY	ETF	150.56	150.66	150.11	150.53	10706885.0
2007-11-02 14:30:00	SPY	ETF	150.51	150.55	149.68	149.8	13973602.0
2007-11-02 15:00:00	SPY	ETF	149.8	150.88	149.71	150.23	14213080.0
2007-11-02 15:30:00	SPY	ETF	150.24	151.13	150.1	151.12	29512036.0
2007-11-02 16:00:00	SPY	ETF	151.07	151.39	150.4	151.25	4711800.0
2007-11-02 16:30:00	SPY	ETF	151.25	151.79	149.24	151.22	3510000.0
2007-11-02 17:00:00	SPY	ETF	151.19	151.33	151.19	151.26	72400.0
2007-11-02 17:30:00	SPY	ETF	151.26	151.3	151.12	151.12	63300.0
2007-11-02 18:00:00	SPY	ETF	151.22	151.22	151.22	151.22	200.0
2007-11-02 18:30:00	SPY	ETF	151.25	151.33	151.25	151.33	5500.0
2007-11-02 19:00:00	SPY	ETF	151.3	151.35	151.3	151.35	1700.0
2007-11-02 19:30:00	SPY	ETF	151.37	151.38	151.28	151.35	2700.0
2007-11-02 04:00:00	QQQ	ETF	54.13	54.13	54.13	54.13	200.0
2007-11-02 05:30:00	QQQ	ETF	54.24	54.24	54.21	54.21	300.0
2007-11-02 07:00:00	QQQ	ETF	54.07	54.09	53.98	53.98	129768.0
2007-11-02 07:30:00	QQQ	ETF	53.96	54.13	53.95	54.13	256845.0
2007-11-02 08:00:00	QQQ	ETF	54.0	54.24	54.0	54.1	402477.0
2007-11-02 08:30:00	QQQ	ETF	54.13	54.64	54.12	54.54	4594778.0
2007-11-02 09:00:00	QQQ	ETF	54.54	54.63	54.42	54.42	1578870.0
2007-11-02 09:30:00	QQQ	ETF	54.42	54.43	53.71	53.89	39552046.0
2007-11-02 10:00:00	QQQ	ETF	53.89	54.01	53.6	54.0099	22270502.0
2007-11-02 10:30:00	QQQ	ETF	54.01	54.19	53.94	54.13	17758565.0
2007-11-02 11:00:00	QQQ	ETF	54.1399	54.28	53.73	53.78	11288789.0
2007-11-02 11:30:00	QQQ	ETF	53.79	54.13	53.71	54.0	12925490.0
2007-11-02 12:00:00	QQQ	ETF	54.01	54.22	53.9299	54.16	11018173.0
2007-11-02 12:30:00	QQQ	ETF	54.17	54.44	54.14	54.43	16433349.0
2007-11-02 13:00:00	QQQ	ETF	54.43	54.5501	54.33	54.42	11211564.0
2007-11-02 13:30:00	QQQ	ETF	54.42	54.46	54.23	54.291	14061727.0
2007-11-02 14:00:00	QQQ	ETF	54.29	54.4	54.17	54.32	9940610.0
2007-11-02 14:30:00	QQQ	ETF	54.32	54.34	54.02	54.07	9390527.0
2007-11-02 15:00:00	QQQ	ETF	54.07	54.34	54.05	54.2699	14146666.0
2007-11-02 15:30:00	QQQ	ETF	54.2601	54.45	54.2	54.44	17553388.0
2007-11-02 16:00:00	QQQ	ETF	54.44	54.54	54.1	54.5	3327823.0

> showing 50 of 5,151 rows — these rows as CSV

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