PREVIEW / etf_30min / 2007-07-16

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-07-16.parquet
  size:    121 KB
  rows:    4,608

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-07-16 05:30:00	SPY	ETF	155.13	155.13	155.13	155.13	15000.0
2007-07-16 06:30:00	SPY	ETF	154.91	154.96	154.91	154.96	12700.0
2007-07-16 07:00:00	SPY	ETF	154.85	154.85	154.77	154.84	83700.0
2007-07-16 07:30:00	SPY	ETF	154.78	154.9	154.72	154.8	188400.0
2007-07-16 08:00:00	SPY	ETF	154.78	154.97	154.74	154.97	1224300.0
2007-07-16 08:30:00	SPY	ETF	155.0	155.1	154.88	154.88	1361900.0
2007-07-16 09:00:00	SPY	ETF	154.88	155.0	154.85	155.0	469600.0
2007-07-16 09:30:00	SPY	ETF	154.99	155.2	154.84	155.04	15645099.0
2007-07-16 10:00:00	SPY	ETF	155.04	155.31	154.87	155.28	7704319.0
2007-07-16 10:30:00	SPY	ETF	155.28	155.42	155.25	155.35	6171949.0
2007-07-16 11:00:00	SPY	ETF	155.34	155.5	155.25	155.4215	4960739.0
2007-07-16 11:30:00	SPY	ETF	155.42	155.53	155.38	155.44	3182300.0
2007-07-16 12:00:00	SPY	ETF	155.45	155.47	155.23	155.28	3182418.0
2007-07-16 12:30:00	SPY	ETF	155.28	155.41	155.25	155.35	2965700.0
2007-07-16 13:00:00	SPY	ETF	155.36	155.4	155.03	155.07	6881400.0
2007-07-16 13:30:00	SPY	ETF	155.07	155.125	154.6	154.6999	9341309.0
2007-07-16 14:00:00	SPY	ETF	154.69	154.9	154.58	154.9	9164314.0
2007-07-16 14:30:00	SPY	ETF	154.89	155.03	154.8	155.0	5090474.0
2007-07-16 15:00:00	SPY	ETF	155.0	155.17	154.85	155.11	6618932.0
2007-07-16 15:30:00	SPY	ETF	155.11	155.11	154.72	154.9	10493243.0
2007-07-16 16:00:00	SPY	ETF	154.91	155.41	154.76	154.88	1871900.0
2007-07-16 16:30:00	SPY	ETF	154.88	154.89	154.8	154.87	388900.0
2007-07-16 17:00:00	SPY	ETF	154.87	154.89	154.83	154.83	9200.0
2007-07-16 18:00:00	SPY	ETF	154.86	154.9	154.85	154.86	15200.0
2007-07-16 18:30:00	SPY	ETF	154.85	154.86	154.81	154.82	7700.0
2007-07-16 19:00:00	SPY	ETF	154.85	154.9	154.85	154.9	3000.0
2007-07-16 19:30:00	SPY	ETF	154.85	154.85	154.85	154.85	1600.0
2007-07-16 04:00:00	QQQ	ETF	49.9	49.9	49.9	49.9	500.0
2007-07-16 07:00:00	QQQ	ETF	49.84	49.84	49.79	49.8	222399.0
2007-07-16 07:30:00	QQQ	ETF	49.8	49.87	49.78	49.81	161592.0
2007-07-16 08:00:00	QQQ	ETF	49.84	49.9	49.82	49.89	385600.0
2007-07-16 08:30:00	QQQ	ETF	49.9	49.94	49.88	49.88	495110.0
2007-07-16 09:00:00	QQQ	ETF	49.88	49.9	49.86	49.9	428003.0
2007-07-16 09:30:00	QQQ	ETF	49.9	49.98	49.84	49.9185	9196123.0
2007-07-16 10:00:00	QQQ	ETF	49.91	50.04	49.87	50.025	8893145.0
2007-07-16 10:30:00	QQQ	ETF	50.03	50.06	50.0	50.05	3627670.0
2007-07-16 11:00:00	QQQ	ETF	50.05	50.08	50.0	50.05	4166431.0
2007-07-16 11:30:00	QQQ	ETF	50.04	50.08	50.01	50.05	2862215.0
2007-07-16 12:00:00	QQQ	ETF	50.06	50.08	49.98	50.0	3607636.0
2007-07-16 12:30:00	QQQ	ETF	50.01	50.06	50.0	50.01	2215066.0
2007-07-16 13:00:00	QQQ	ETF	50.02	50.05	49.9	49.9	4818039.0
2007-07-16 13:30:00	QQQ	ETF	49.91	49.91	49.78	49.8	6162297.0
2007-07-16 14:00:00	QQQ	ETF	49.805	49.87	49.76	49.85	4068319.0
2007-07-16 14:30:00	QQQ	ETF	49.86	49.94	49.84	49.91	5980289.0
2007-07-16 15:00:00	QQQ	ETF	49.91	49.97	49.88	49.95	4626240.0
2007-07-16 15:30:00	QQQ	ETF	49.94	49.95	49.8	49.86	10651287.0
2007-07-16 16:00:00	QQQ	ETF	49.85	49.92	49.85	49.91	1238942.0
2007-07-16 16:30:00	QQQ	ETF	49.91	49.91	49.88	49.9	142638.0
2007-07-16 17:00:00	QQQ	ETF	49.91	49.92	49.9	49.92	2000.0
2007-07-16 17:30:00	QQQ	ETF	49.91	49.92	49.91	49.92	5000.0

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

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