PREVIEW / etf_30min / 2007-09-20

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-09-20.parquet
  size:    128 KB
  rows:    4,820

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-09-20 04:00:00	SPY	ETF	152.93	152.93	152.9	152.9	3200.0
2007-09-20 06:00:00	SPY	ETF	152.75	152.78	152.72	152.72	3700.0
2007-09-20 06:30:00	SPY	ETF	152.77	152.8	152.77	152.77	20000.0
2007-09-20 07:00:00	SPY	ETF	152.85	152.85	152.67	152.83	688100.0
2007-09-20 07:30:00	SPY	ETF	152.8	152.88	152.6	152.85	1315100.0
2007-09-20 08:00:00	SPY	ETF	152.77	153.29	152.65	152.85	6466000.0
2007-09-20 08:30:00	SPY	ETF	152.86	153.26	152.74	153.22	2152300.0
2007-09-20 09:00:00	SPY	ETF	153.21	153.35	153.02	153.35	2095086.0
2007-09-20 09:30:00	SPY	ETF	153.34	153.36	152.77	153.01	15972991.0
2007-09-20 10:00:00	SPY	ETF	153.01	153.43	152.85	153.12	9456000.0
2007-09-20 10:30:00	SPY	ETF	153.13	153.27	152.96	153.08	11801100.0
2007-09-20 11:00:00	SPY	ETF	153.08	153.31	153.01	153.081	7223500.0
2007-09-20 11:30:00	SPY	ETF	153.09	153.17	152.89	153.06	6973400.0
2007-09-20 12:00:00	SPY	ETF	153.06	153.33	153.0	153.0	10563700.0
2007-09-20 12:30:00	SPY	ETF	153.01	153.06	152.85	153.05	6886600.0
2007-09-20 13:00:00	SPY	ETF	153.05	153.09	152.68	152.79	7816800.0
2007-09-20 13:30:00	SPY	ETF	152.79	152.98	152.6	152.87	7851101.0
2007-09-20 14:00:00	SPY	ETF	152.88	152.949	152.54	152.59	14395400.0
2007-09-20 14:30:00	SPY	ETF	152.5999	153.3955	152.22	152.35	18289000.0
2007-09-20 15:00:00	SPY	ETF	152.35	152.59	152.11	152.48	12931100.0
2007-09-20 15:30:00	SPY	ETF	152.48	152.69	152.31	152.33	14170300.0
2007-09-20 16:00:00	SPY	ETF	152.33	152.65	152.23	152.3	7439600.0
2007-09-20 16:30:00	SPY	ETF	152.34	152.45	152.34	152.37	195200.0
2007-09-20 17:00:00	SPY	ETF	152.34	152.34	152.11	152.17	106100.0
2007-09-20 17:30:00	SPY	ETF	152.15	152.22	152.14	152.2	4500.0
2007-09-20 18:00:00	SPY	ETF	152.17	152.38	152.16	152.27	342800.0
2007-09-20 18:30:00	SPY	ETF	152.29	152.29	152.23	152.23	5100.0
2007-09-20 19:00:00	SPY	ETF	152.22	152.26	152.19	152.26	900.0
2007-09-20 19:30:00	SPY	ETF	152.26	152.37	152.24	152.37	2000.0
2007-09-20 07:00:00	QQQ	ETF	50.01	50.01	49.92	49.98	787998.0
2007-09-20 07:30:00	QQQ	ETF	49.98	49.99	49.91	49.95	402739.0
2007-09-20 08:00:00	QQQ	ETF	49.94	50.05	49.94	49.97	5229253.0
2007-09-20 08:30:00	QQQ	ETF	49.97	50.09	49.97	50.08	1744048.0
2007-09-20 09:00:00	QQQ	ETF	50.07	50.09	50.01	50.06	937559.0
2007-09-20 09:30:00	QQQ	ETF	50.07	50.18	49.97	50.12	12889470.0
2007-09-20 10:00:00	QQQ	ETF	50.12	50.26	50.1	50.15	8759623.0
2007-09-20 10:30:00	QQQ	ETF	50.159	50.2	50.09	50.14	4738741.0
2007-09-20 11:00:00	QQQ	ETF	50.15	50.26	50.14	50.16	5092455.0
2007-09-20 11:30:00	QQQ	ETF	50.16	50.18	50.06	50.132	4084542.0
2007-09-20 12:00:00	QQQ	ETF	50.1301	50.25	50.13	50.15	3439209.0
2007-09-20 12:30:00	QQQ	ETF	50.14	50.22	50.1	50.19	2478563.0
2007-09-20 13:00:00	QQQ	ETF	50.195	50.2	50.07	50.1099	2814739.0
2007-09-20 13:30:00	QQQ	ETF	50.1	50.18	50.04	50.15	4155810.0
2007-09-20 14:00:00	QQQ	ETF	50.14	50.17	50.0	50.03	4824584.0
2007-09-20 14:30:00	QQQ	ETF	50.03	50.08	49.92	49.9801	8383212.0
2007-09-20 15:00:00	QQQ	ETF	49.982	50.07	49.92	50.03	4949243.0
2007-09-20 15:30:00	QQQ	ETF	50.03	50.11	49.98	49.98	10360703.0
2007-09-20 16:00:00	QQQ	ETF	49.99	50.09	49.98	50.04	2920606.0
2007-09-20 16:30:00	QQQ	ETF	50.06	50.07	50.04	50.05	5208360.0
2007-09-20 17:00:00	QQQ	ETF	50.04	50.05	49.96	49.97	164238.0

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

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