PREVIEW / etf_30min / 2007-06-14

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-06-14.parquet
  size:    112 KB
  rows:    4,385

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-06-14 06:00:00	SPY	ETF	151.95	151.95	151.95	151.95	15000.0
2007-06-14 06:30:00	SPY	ETF	151.91	152.0	151.91	151.99	6200.0
2007-06-14 07:00:00	SPY	ETF	151.92	152.07	151.91	152.06	92700.0
2007-06-14 07:30:00	SPY	ETF	152.07	152.3	152.02	152.24	268800.0
2007-06-14 08:00:00	SPY	ETF	152.28	152.37	151.94	152.3	2025900.0
2007-06-14 08:30:00	SPY	ETF	152.27	152.32	151.85	152.03	5983000.0
2007-06-14 09:00:00	SPY	ETF	152.06	152.1	151.98	152.06	1468586.0
2007-06-14 09:30:00	SPY	ETF	152.08	152.81	152.03	152.77	23634668.0
2007-06-14 10:00:00	SPY	ETF	152.77	152.78	152.58	152.68	9195144.0
2007-06-14 10:30:00	SPY	ETF	152.69	153.12	152.66	152.79	12822705.0
2007-06-14 11:00:00	SPY	ETF	152.79	152.88	152.49	152.64	10596300.0
2007-06-14 11:30:00	SPY	ETF	152.63	152.78	152.31	152.47	10836922.0
2007-06-14 12:00:00	SPY	ETF	152.47	152.85	152.44	152.72	8458227.0
2007-06-14 12:30:00	SPY	ETF	152.72	152.82	152.66	152.72	2657598.0
2007-06-14 13:00:00	SPY	ETF	152.73	152.88	152.66	152.69	4084088.0
2007-06-14 13:30:00	SPY	ETF	152.68	152.82	152.57	152.73	13404543.0
2007-06-14 14:00:00	SPY	ETF	152.73	152.78	152.58	152.69	6096371.0
2007-06-14 14:30:00	SPY	ETF	152.7	152.91	152.67	152.78	6389067.0
2007-06-14 15:00:00	SPY	ETF	152.79	152.99	152.74	152.83	7930475.0
2007-06-14 15:30:00	SPY	ETF	152.84	152.96	152.64	152.71	13448437.0
2007-06-14 16:00:00	SPY	ETF	152.73	152.89	152.69	152.82	3700900.0
2007-06-14 16:30:00	SPY	ETF	152.84	152.87	152.79	152.79	84000.0
2007-06-14 17:00:00	SPY	ETF	152.81	152.86	152.77	152.86	63800.0
2007-06-14 17:30:00	SPY	ETF	152.88	152.88	152.63	152.63	1502500.0
2007-06-14 18:00:00	SPY	ETF	152.84	152.84	152.77	152.79	11600.0
2007-06-14 18:30:00	SPY	ETF	152.79	152.8	152.78	152.79	241900.0
2007-06-14 19:00:00	SPY	ETF	152.78	152.83	152.77	152.79	100400.0
2007-06-14 19:30:00	SPY	ETF	152.79	152.79	152.78	152.79	27800.0
2007-06-14 04:00:00	QQQ	ETF	47.1	47.1	47.1	47.1	500.0
2007-06-14 04:30:00	QQQ	ETF	47.15	47.15	47.15	47.15	1000.0
2007-06-14 07:00:00	QQQ	ETF	47.1	47.12	47.07	47.12	515500.0
2007-06-14 07:30:00	QQQ	ETF	47.12	47.19	47.12	47.16	243075.0
2007-06-14 08:00:00	QQQ	ETF	47.16	47.21	47.14	47.2	1564706.0
2007-06-14 08:30:00	QQQ	ETF	47.18	47.2	47.02	47.12	2895869.0
2007-06-14 09:00:00	QQQ	ETF	47.12	47.13	47.09	47.1	369399.0
2007-06-14 09:30:00	QQQ	ETF	47.1	47.42	47.09	47.39	16849473.0
2007-06-14 10:00:00	QQQ	ETF	47.39	47.4	47.32	47.35	9553211.0
2007-06-14 10:30:00	QQQ	ETF	47.34	47.49	47.33	47.3605	11886685.0
2007-06-14 11:00:00	QQQ	ETF	47.3685	47.4	47.3	47.33	6682012.0
2007-06-14 11:30:00	QQQ	ETF	47.33	47.37	47.22	47.26	5532645.0
2007-06-14 12:00:00	QQQ	ETF	47.26	47.37	47.25	47.32	4843724.0
2007-06-14 12:30:00	QQQ	ETF	47.31	47.36	47.29	47.33	4377233.0
2007-06-14 13:00:00	QQQ	ETF	47.32	47.39	47.32	47.35	2901576.0
2007-06-14 13:30:00	QQQ	ETF	47.35	47.42	47.3	47.375	3911487.0
2007-06-14 14:00:00	QQQ	ETF	47.38	47.4	47.29	47.37	5175976.0
2007-06-14 14:30:00	QQQ	ETF	47.37	47.47	47.36	47.41	6810402.0
2007-06-14 15:00:00	QQQ	ETF	47.41	47.46	47.4	47.42	2824721.0
2007-06-14 15:30:00	QQQ	ETF	47.42	47.46	47.32	47.36	10129732.0
2007-06-14 16:00:00	QQQ	ETF	47.35	47.38	47.308	47.36	2882890.0
2007-06-14 16:30:00	QQQ	ETF	47.37	47.37	47.34	47.35	113582.0

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

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