PREVIEW / etf_30min / 2007-07-19

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-07-19.parquet
  size:    116 KB
  rows:    4,561

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-19 04:00:00	SPY	ETF	154.89	154.89	154.89	154.89	4900.0
2007-07-19 04:30:00	SPY	ETF	154.86	154.86	154.86	154.86	3000.0
2007-07-19 05:30:00	SPY	ETF	154.82	154.87	154.81	154.87	36300.0
2007-07-19 06:00:00	SPY	ETF	154.77	154.77	154.77	154.77	100.0
2007-07-19 06:30:00	SPY	ETF	154.87	155.0	154.87	155.0	91200.0
2007-07-19 07:00:00	SPY	ETF	154.99	155.14	154.98	155.1	831000.0
2007-07-19 07:30:00	SPY	ETF	155.08	155.1	154.98	155.03	385300.0
2007-07-19 08:00:00	SPY	ETF	154.61	155.12	154.3	155.05	1236500.0
2007-07-19 08:30:00	SPY	ETF	155.09	155.28	155.07	155.27	2584507.0
2007-07-19 09:00:00	SPY	ETF	155.27	155.32	155.19	155.19	1860201.0
2007-07-19 09:30:00	SPY	ETF	155.2	155.53	155.14	155.34	18460221.0
2007-07-19 10:00:00	SPY	ETF	155.33	155.38	155.04	155.23	12047634.0
2007-07-19 10:30:00	SPY	ETF	155.23	155.27	154.78	154.88	18162899.0
2007-07-19 11:00:00	SPY	ETF	154.88	155.24	154.87	155.09	8815978.0
2007-07-19 11:30:00	SPY	ETF	155.1	155.17	154.97	155.06	5228223.0
2007-07-19 12:00:00	SPY	ETF	155.06	155.33	154.89	155.26	7432901.0
2007-07-19 12:30:00	SPY	ETF	155.26	155.38	155.16	155.2585	5199700.0
2007-07-19 13:00:00	SPY	ETF	155.25	155.27	155.09	155.18	4036743.0
2007-07-19 13:30:00	SPY	ETF	155.18	155.34	155.1	155.24	4493350.0
2007-07-19 14:00:00	SPY	ETF	155.25	155.275	154.75	154.91	15437770.0
2007-07-19 14:30:00	SPY	ETF	154.91	155.09	154.86	155.03	7228819.0
2007-07-19 15:00:00	SPY	ETF	155.03	155.3	155.0	155.24	9414406.0
2007-07-19 15:30:00	SPY	ETF	155.23	155.39	155.15	155.21	13172685.0
2007-07-19 16:00:00	SPY	ETF	155.24	155.275	154.88	154.93	4119800.0
2007-07-19 16:30:00	SPY	ETF	154.93	154.95	154.68	154.72	1403300.0
2007-07-19 17:00:00	SPY	ETF	154.72	154.77	154.64	154.64	182400.0
2007-07-19 17:30:00	SPY	ETF	154.65	154.85	154.65	154.68	78800.0
2007-07-19 18:00:00	SPY	ETF	155.07	155.07	154.7	154.8	67700.0
2007-07-19 18:30:00	SPY	ETF	154.79	154.86	154.79	154.84	21500.0
2007-07-19 19:00:00	SPY	ETF	154.84	154.84	154.79	154.83	30100.0
2007-07-19 19:30:00	SPY	ETF	154.81	154.81	154.8	154.8	2500.0
2007-07-19 04:00:00	QQQ	ETF	50.33	50.33	50.33	50.33	500.0
2007-07-19 05:00:00	QQQ	ETF	50.37	50.37	50.37	50.37	600.0
2007-07-19 06:00:00	QQQ	ETF	50.29	50.29	50.29	50.29	100.0
2007-07-19 06:30:00	QQQ	ETF	50.36	50.41	50.36	50.41	123201.0
2007-07-19 07:00:00	QQQ	ETF	50.41	50.48	50.4	50.46	190702.0
2007-07-19 07:30:00	QQQ	ETF	50.46	50.46	50.41	50.42	69681.0
2007-07-19 08:00:00	QQQ	ETF	50.41	50.46	50.4	50.45	404910.0
2007-07-19 08:30:00	QQQ	ETF	50.45	50.53	50.43	50.52	1738264.0
2007-07-19 09:00:00	QQQ	ETF	50.52	50.53	50.42	50.42	1845099.0
2007-07-19 09:30:00	QQQ	ETF	50.41	50.5	50.38	50.45	14618592.0
2007-07-19 10:00:00	QQQ	ETF	50.45	50.47	50.36	50.43	7095938.0
2007-07-19 10:30:00	QQQ	ETF	50.44	50.45	50.31	50.36	9998648.0
2007-07-19 11:00:00	QQQ	ETF	50.36	50.47	50.36	50.42	6743846.0
2007-07-19 11:30:00	QQQ	ETF	50.42	50.44	50.38	50.41	3682593.0
2007-07-19 12:00:00	QQQ	ETF	50.418	50.53	50.37	50.5199	7590479.0
2007-07-19 12:30:00	QQQ	ETF	50.51	50.6	50.47	50.55	4752262.0
2007-07-19 13:00:00	QQQ	ETF	50.55	50.57	50.51	50.56	6913585.0
2007-07-19 13:30:00	QQQ	ETF	50.56	50.66	50.53	50.64	4138256.0
2007-07-19 14:00:00	QQQ	ETF	50.63	50.64	50.47	50.54	10458733.0

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

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