PREVIEW / etf_30min / 2007-12-20

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-12-20.parquet
  size:    144 KB
  rows:    5,300

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-12-20 04:00:00	SPY	ETF	146.17	146.2	146.17	146.2	4000.0
2007-12-20 04:30:00	SPY	ETF	146.16	146.16	146.14	146.14	3000.0
2007-12-20 05:30:00	SPY	ETF	146.21	146.21	146.21	146.21	100.0
2007-12-20 06:00:00	SPY	ETF	146.15	146.15	146.02	146.02	56300.0
2007-12-20 06:30:00	SPY	ETF	146.0	146.25	145.98	146.25	31300.0
2007-12-20 07:00:00	SPY	ETF	146.21	146.28	146.14	146.21	71100.0
2007-12-20 07:30:00	SPY	ETF	146.18	146.18	145.8	146.05	246100.0
2007-12-20 08:00:00	SPY	ETF	146.0	146.59	146.0	146.43	4212400.0
2007-12-20 08:30:00	SPY	ETF	146.43	146.65	146.24	146.54	2602200.0
2007-12-20 09:00:00	SPY	ETF	146.54	146.88	146.54	146.85	2442900.0
2007-12-20 09:30:00	SPY	ETF	146.84	146.86	146.01	146.02	15659014.0
2007-12-20 10:00:00	SPY	ETF	146.02	146.17	145.7	145.83	18684187.0
2007-12-20 10:30:00	SPY	ETF	145.83	146.78	145.5	145.71	17284373.0
2007-12-20 11:00:00	SPY	ETF	145.71	146.15	145.34	145.58	14551439.0
2007-12-20 11:30:00	SPY	ETF	145.58	145.68	145.31	145.5	7044259.0
2007-12-20 12:00:00	SPY	ETF	145.51	145.67	145.2	145.61	9882477.0
2007-12-20 12:30:00	SPY	ETF	145.61	145.65	145.18	145.41	5493805.0
2007-12-20 13:00:00	SPY	ETF	145.42	146.84	145.41	145.81	11981609.0
2007-12-20 13:30:00	SPY	ETF	145.8	146.04	145.63	145.98	5383348.0
2007-12-20 14:00:00	SPY	ETF	145.98	146.27	145.77	146.24	16035138.0
2007-12-20 14:30:00	SPY	ETF	146.24	146.58	146.14	146.33	14836971.0
2007-12-20 15:00:00	SPY	ETF	146.33	146.48	146.04	146.065	17543316.0
2007-12-20 15:30:00	SPY	ETF	146.07	146.59	145.93	146.53	20084219.0
2007-12-20 16:00:00	SPY	ETF	146.5101	146.86	146.048	146.82	24728500.0
2007-12-20 16:30:00	SPY	ETF	146.82	146.9	146.78	146.79	345000.0
2007-12-20 17:00:00	SPY	ETF	146.77	146.79	146.58	146.72	60600.0
2007-12-20 17:30:00	SPY	ETF	146.73	146.76	146.68	146.76	21100.0
2007-12-20 18:00:00	SPY	ETF	146.77	146.86	146.76	146.8	24400.0
2007-12-20 18:30:00	SPY	ETF	146.8	146.91	146.72	146.89	85400.0
2007-12-20 19:00:00	SPY	ETF	146.89	146.89	146.77	146.77	15500.0
2007-12-20 19:30:00	SPY	ETF	146.78	146.85	146.73	146.83	14400.0
2007-12-20 07:00:00	QQQ	ETF	50.29	50.31	50.23	50.29	311301.0
2007-12-20 07:30:00	QQQ	ETF	50.27	50.3	50.17	50.28	432076.0
2007-12-20 08:00:00	QQQ	ETF	50.26	50.45	50.24	50.37	2306069.0
2007-12-20 08:30:00	QQQ	ETF	50.37	50.48	50.35	50.46	1218452.0
2007-12-20 09:00:00	QQQ	ETF	50.46	50.66	50.46	50.66	1865883.0
2007-12-20 09:30:00	QQQ	ETF	50.66	50.67	50.36	50.3614	11850245.0
2007-12-20 10:00:00	QQQ	ETF	50.3601	50.42	50.22	50.32	9739857.0
2007-12-20 10:30:00	QQQ	ETF	50.32	50.55	50.29	50.36	8738368.0
2007-12-20 11:00:00	QQQ	ETF	50.36	50.39	50.23	50.3799	9688051.0
2007-12-20 11:30:00	QQQ	ETF	50.3799	50.39	50.29	50.31	4699686.0
2007-12-20 12:00:00	QQQ	ETF	50.31	50.43	50.2	50.39	9254681.0
2007-12-20 12:30:00	QQQ	ETF	50.4	50.41	50.24	50.3	7442369.0
2007-12-20 13:00:00	QQQ	ETF	50.29	50.56	50.28	50.48	12274488.0
2007-12-20 13:30:00	QQQ	ETF	50.49	50.59	50.45	50.58	4963711.0
2007-12-20 14:00:00	QQQ	ETF	50.58	50.84	50.51	50.83	22593103.0
2007-12-20 14:30:00	QQQ	ETF	50.83	50.93	50.77	50.83	11183386.0
2007-12-20 15:00:00	QQQ	ETF	50.8201	50.94	50.68	50.7899	17669586.0
2007-12-20 15:30:00	QQQ	ETF	50.78	50.96	50.76	50.92	23366916.0
2007-12-20 16:00:00	QQQ	ETF	50.93	51.15	50.86	51.14	7916989.0

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

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