PREVIEW / etf_30min / 2007-07-17

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-07-17.parquet
  size:    119 KB
  rows:    4,618

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-17 04:00:00	SPY	ETF	154.75	154.75	154.75	154.75	100.0
2007-07-17 05:30:00	SPY	ETF	154.5	154.5	154.5	154.5	1000.0
2007-07-17 06:00:00	SPY	ETF	154.56	154.56	154.56	154.56	2000.0
2007-07-17 06:30:00	SPY	ETF	154.66	154.67	154.66	154.67	6000.0
2007-07-17 07:00:00	SPY	ETF	154.73	154.73	154.57	154.6	105000.0
2007-07-17 07:30:00	SPY	ETF	154.66	155.05	154.66	154.96	177100.0
2007-07-17 08:00:00	SPY	ETF	154.89	155.06	154.85	154.9	854100.0
2007-07-17 08:30:00	SPY	ETF	154.9	155.1	154.5	155.0	2181100.0
2007-07-17 09:00:00	SPY	ETF	155.0	155.1	154.89	155.01	1268500.0
2007-07-17 09:30:00	SPY	ETF	155.01	155.48	154.94	155.32	14199689.0
2007-07-17 10:00:00	SPY	ETF	155.33	156.0	155.01	155.38	10623880.0
2007-07-17 10:30:00	SPY	ETF	155.38	155.4	155.21	155.32	6941020.0
2007-07-17 11:00:00	SPY	ETF	155.33	155.46	155.02	155.18	12291119.0
2007-07-17 11:30:00	SPY	ETF	155.18	155.28	155.07	155.17	4180722.0
2007-07-17 12:00:00	SPY	ETF	155.17	155.22	154.85	154.86	7730062.0
2007-07-17 12:30:00	SPY	ETF	154.87	154.91	154.68	154.84	8109864.0
2007-07-17 13:00:00	SPY	ETF	154.84	154.98	154.7	154.85	5972799.0
2007-07-17 13:30:00	SPY	ETF	154.85	155.29	154.82	155.13	7265340.0
2007-07-17 14:00:00	SPY	ETF	155.12	155.37	155.07	155.35	6003257.0
2007-07-17 14:30:00	SPY	ETF	155.35	155.48	155.25	155.4	5973780.0
2007-07-17 15:00:00	SPY	ETF	155.4	155.41	155.13	155.22	6554592.0
2007-07-17 15:30:00	SPY	ETF	155.22	155.3587	154.85	154.85	12937014.0
2007-07-17 16:00:00	SPY	ETF	154.85	155.2613	154.57	154.65	3785000.0
2007-07-17 16:30:00	SPY	ETF	154.65	154.75	154.38	154.41	2091700.0
2007-07-17 17:00:00	SPY	ETF	154.42	154.52	154.19	154.2	1976600.0
2007-07-17 17:30:00	SPY	ETF	154.25	154.28	153.35	153.41	1063600.0
2007-07-17 18:00:00	SPY	ETF	153.43	154.75	153.4	153.91	1464300.0
2007-07-17 18:30:00	SPY	ETF	153.9	154.02	153.88	153.94	82600.0
2007-07-17 19:00:00	SPY	ETF	153.9	153.94	153.87	153.94	34800.0
2007-07-17 19:30:00	SPY	ETF	153.95	154.01	153.86	153.87	30100.0
2007-07-17 07:00:00	QQQ	ETF	49.82	49.83	49.82	49.83	31100.0
2007-07-17 07:30:00	QQQ	ETF	49.84	49.96	49.84	49.95	425484.0
2007-07-17 08:00:00	QQQ	ETF	49.95	49.96	49.9	49.91	365474.0
2007-07-17 08:30:00	QQQ	ETF	49.89	49.99	49.86	49.95	1409432.0
2007-07-17 09:00:00	QQQ	ETF	49.96	49.98	49.94	49.97	1037574.0
2007-07-17 09:30:00	QQQ	ETF	49.97	50.08	49.94	50.0485	11382715.0
2007-07-17 10:00:00	QQQ	ETF	50.04	50.07	49.92	50.04	11401879.0
2007-07-17 10:30:00	QQQ	ETF	50.04	50.09	50.01	50.07	6791333.0
2007-07-17 11:00:00	QQQ	ETF	50.07	50.13	49.98	50.02	8832348.0
2007-07-17 11:30:00	QQQ	ETF	50.02	50.06	50.01	50.0485	3715871.0
2007-07-17 12:00:00	QQQ	ETF	50.05	50.07	49.98	49.99	4742407.0
2007-07-17 12:30:00	QQQ	ETF	49.9985	50.02	49.93	50.0	5120515.0
2007-07-17 13:00:00	QQQ	ETF	49.99	50.03	49.97	50.01	4524164.0
2007-07-17 13:30:00	QQQ	ETF	50.02	50.21	50.01	50.1795	11919050.0
2007-07-17 14:00:00	QQQ	ETF	50.18	50.26	50.17	50.26	8498299.0
2007-07-17 14:30:00	QQQ	ETF	50.26	50.3	50.23	50.2605	8645041.0
2007-07-17 15:00:00	QQQ	ETF	50.27	50.28	50.21	50.26	4187623.0
2007-07-17 15:30:00	QQQ	ETF	50.25	50.28	50.18	50.21	11697819.0
2007-07-17 16:00:00	QQQ	ETF	50.2	50.25	49.93	50.0	5304565.0
2007-07-17 16:30:00	QQQ	ETF	50.02	50.27	49.98	50.0	3083751.0

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

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