PREVIEW / etf_30min / 2007-01-18

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-01-18.parquet
  size:    98 KB
  rows:    3,377

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-01-18 04:00:00	SPY	ETF	143.26	143.26	143.26	143.26	400.0
2007-01-18 05:00:00	SPY	ETF	143.28	143.3	143.28	143.3	15000.0
2007-01-18 06:00:00	SPY	ETF	143.26	143.26	143.26	143.26	10000.0
2007-01-18 07:00:00	SPY	ETF	143.11	143.17	143.1	143.13	6100.0
2007-01-18 07:30:00	SPY	ETF	143.15	143.15	143.07	143.1	254600.0
2007-01-18 08:00:00	SPY	ETF	143.05	143.17	143.04	143.17	572500.0
2007-01-18 08:30:00	SPY	ETF	143.12	143.28	143.02	143.27	3571400.0
2007-01-18 09:00:00	SPY	ETF	143.27	143.41	143.18	143.18	906600.0
2007-01-18 09:30:00	SPY	ETF	143.17	143.26	142.98	143.06	7604900.0
2007-01-18 10:00:00	SPY	ETF	143.06	143.16	142.45	142.69	14586800.0
2007-01-18 10:30:00	SPY	ETF	142.68	142.82	142.48	142.67	4361400.0
2007-01-18 11:00:00	SPY	ETF	142.68	142.93	142.65	142.69	5940200.0
2007-01-18 11:30:00	SPY	ETF	142.69	142.9	142.66	142.75	2320100.0
2007-01-18 12:00:00	SPY	ETF	142.75	143.0	142.63	142.74	3587900.0
2007-01-18 12:30:00	SPY	ETF	142.73	142.86	142.64	142.78	1574800.0
2007-01-18 13:00:00	SPY	ETF	142.79	142.84	142.67	142.75	2029600.0
2007-01-18 13:30:00	SPY	ETF	142.73	142.85	142.66	142.71	1728800.0
2007-01-18 14:00:00	SPY	ETF	142.7	142.8	142.55	142.57	2998500.0
2007-01-18 14:30:00	SPY	ETF	142.57	142.62	142.31	142.36	4644800.0
2007-01-18 15:00:00	SPY	ETF	142.36	142.57	142.31	142.56	3519500.0
2007-01-18 15:30:00	SPY	ETF	142.57	142.6	142.45	142.45	3726800.0
2007-01-18 16:00:00	SPY	ETF	142.45	142.53	142.39	142.41	1569000.0
2007-01-18 16:30:00	SPY	ETF	142.41	142.45	142.33	142.4	547900.0
2007-01-18 17:00:00	SPY	ETF	142.4	142.42	142.35	142.4	20000.0
2007-01-18 17:30:00	SPY	ETF	142.36	142.36	142.33	142.35	33900.0
2007-01-18 18:00:00	SPY	ETF	142.35	142.4	142.35	142.38	51600.0
2007-01-18 18:30:00	SPY	ETF	142.38	142.45	142.38	142.42	28400.0
2007-01-18 19:00:00	SPY	ETF	142.42	142.42	142.42	142.42	1000.0
2007-01-18 19:30:00	SPY	ETF	142.41	142.41	142.4	142.4	1600.0
2007-01-18 05:00:00	QQQ	ETF	44.93	44.93	44.93	44.93	10080.0
2007-01-18 05:30:00	QQQ	ETF	44.92	44.92	44.92	44.92	300.0
2007-01-18 06:30:00	QQQ	ETF	44.83	44.83	44.8	44.8	192200.0
2007-01-18 07:00:00	QQQ	ETF	44.81	44.83	44.81	44.83	44813.0
2007-01-18 07:30:00	QQQ	ETF	44.83	44.84	44.78	44.78	861798.0
2007-01-18 08:00:00	QQQ	ETF	44.78	44.82	44.78	44.82	2201136.0
2007-01-18 08:30:00	QQQ	ETF	44.82	44.88	44.75	44.84	3854185.0
2007-01-18 09:00:00	QQQ	ETF	44.84	44.88	44.79	44.79	4639617.0
2007-01-18 09:30:00	QQQ	ETF	44.79	44.84	44.66	44.68	17727400.0
2007-01-18 10:00:00	QQQ	ETF	44.68	44.84	44.26	44.4	46070300.0
2007-01-18 10:30:00	QQQ	ETF	44.4	44.43	44.3	44.32	12598000.0
2007-01-18 11:00:00	QQQ	ETF	44.33	44.45	44.32	44.38	12423100.0
2007-01-18 11:30:00	QQQ	ETF	44.39	44.42	44.35	44.37	6076300.0
2007-01-18 12:00:00	QQQ	ETF	44.37	44.45	41.4	44.29	8399800.0
2007-01-18 12:30:00	QQQ	ETF	44.29	44.36	44.21	44.32	5227300.0
2007-01-18 13:00:00	QQQ	ETF	44.32	44.43	44.2	44.23	5740300.0
2007-01-18 13:30:00	QQQ	ETF	44.24	44.32	44.17	44.21	4676700.0
2007-01-18 14:00:00	QQQ	ETF	44.2	44.3	44.1	44.11	8151300.0
2007-01-18 14:30:00	QQQ	ETF	44.11	44.16	43.95	44.03	13659100.0
2007-01-18 15:00:00	QQQ	ETF	44.03	44.15	43.99	44.15	7950800.0
2007-01-18 15:30:00	QQQ	ETF	44.15	44.19	44.05	44.07	14687200.0

> showing 50 of 3,377 rows — these rows as CSV

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