PREVIEW / etf_30min / 2007-01-04

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-01-04.parquet
  size:    93 KB
  rows:    3,259

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-04 06:30:00	SPY	ETF	141.09	141.09	141.09	141.09	1000.0
2007-01-04 07:00:00	SPY	ETF	141.06	141.14	141.03	141.14	11300.0
2007-01-04 07:30:00	SPY	ETF	141.1	141.16	141.09	141.15	159800.0
2007-01-04 08:00:00	SPY	ETF	141.17	141.2	141.03	141.2	400700.0
2007-01-04 08:30:00	SPY	ETF	141.15	141.27	141.14	141.21	346300.0
2007-01-04 09:00:00	SPY	ETF	141.22	141.27	141.2	141.21	124000.0
2007-01-04 09:30:00	SPY	ETF	141.23	141.5	140.94	141.27	9232300.0
2007-01-04 10:00:00	SPY	ETF	141.27	141.36	140.61	140.89	7683600.0
2007-01-04 10:30:00	SPY	ETF	140.88	141.57	140.87	141.41	9910000.0
2007-01-04 11:00:00	SPY	ETF	141.4	141.62	141.33	141.37	4950800.0
2007-01-04 11:30:00	SPY	ETF	141.37	141.66	141.32	141.47	4250800.0
2007-01-04 12:00:00	SPY	ETF	141.46	141.55	141.35	141.4	1804300.0
2007-01-04 12:30:00	SPY	ETF	141.4	141.54	141.36	141.42	1387000.0
2007-01-04 13:00:00	SPY	ETF	141.425	141.49	141.1	141.28	2290200.0
2007-01-04 13:30:00	SPY	ETF	141.28	141.42	141.1	141.3	2335300.0
2007-01-04 14:00:00	SPY	ETF	141.3	141.38	141.16	141.31	2270800.0
2007-01-04 14:30:00	SPY	ETF	141.3	141.79	141.27	141.76	6143000.0
2007-01-04 15:00:00	SPY	ETF	141.76	141.85	141.69	141.74	3605000.0
2007-01-04 15:30:00	SPY	ETF	141.73	142.05	141.62	141.67	8121900.0
2007-01-04 16:00:00	SPY	ETF	141.67	141.75	141.4982	141.73	1635600.0
2007-01-04 16:30:00	SPY	ETF	141.73	141.73	141.67	141.73	401000.0
2007-01-04 17:00:00	SPY	ETF	141.75	141.77	141.75	141.77	3300.0
2007-01-04 17:30:00	SPY	ETF	141.76	141.77	141.75	141.75	253900.0
2007-01-04 18:00:00	SPY	ETF	141.76	141.76	141.71	141.73	13100.0
2007-01-04 18:30:00	SPY	ETF	141.77	141.77	141.77	141.77	900.0
2007-01-04 19:00:00	SPY	ETF	141.72	141.72	141.69	141.7	3800.0
2007-01-04 19:30:00	SPY	ETF	141.78	141.78	141.78	141.78	500.0
2007-01-04 07:00:00	QQQ	ETF	43.17	43.2	43.1	43.19	119016.0
2007-01-04 07:30:00	QQQ	ETF	43.16	43.17	43.15	43.16	22000.0
2007-01-04 08:00:00	QQQ	ETF	43.17	43.26	43.16	43.23	372697.0
2007-01-04 08:30:00	QQQ	ETF	43.24	43.3	43.23	43.25	243672.0
2007-01-04 09:00:00	QQQ	ETF	43.27	43.29	43.26	43.29	216620.0
2007-01-04 09:30:00	QQQ	ETF	43.29	43.45	43.17	43.39	17075300.0
2007-01-04 10:00:00	QQQ	ETF	43.39	43.42	43.15	43.3	13607100.0
2007-01-04 10:30:00	QQQ	ETF	43.3	43.78	43.29	43.74	20167800.0
2007-01-04 11:00:00	QQQ	ETF	43.75	43.86	43.68	43.73	12102200.0
2007-01-04 11:30:00	QQQ	ETF	43.72	43.87	43.69	43.77	6833200.0
2007-01-04 12:00:00	QQQ	ETF	43.76	43.78	43.7	43.74	2717100.0
2007-01-04 12:30:00	QQQ	ETF	43.74	43.82	43.72	43.77	2189200.0
2007-01-04 13:00:00	QQQ	ETF	43.78	43.81	43.62	43.7	5106900.0
2007-01-04 13:30:00	QQQ	ETF	43.69	43.8	43.64	43.71	5642600.0
2007-01-04 14:00:00	QQQ	ETF	43.72	43.8	43.68	43.77	4492600.0
2007-01-04 14:30:00	QQQ	ETF	43.77	44.02	43.77	44.0	12272200.0
2007-01-04 15:00:00	QQQ	ETF	44.01	44.05	43.97	44.01	6705000.0
2007-01-04 15:30:00	QQQ	ETF	44.01	44.21	44.01	44.07	14437000.0
2007-01-04 16:00:00	QQQ	ETF	44.06	44.13	44.04	44.11	1599200.0
2007-01-04 16:30:00	QQQ	ETF	44.12	44.17	44.11	44.16	787730.0
2007-01-04 17:00:00	QQQ	ETF	44.16	44.2	44.15	44.17	476121.0
2007-01-04 17:30:00	QQQ	ETF	44.17	44.2	44.15	44.15	57307.0
2007-01-04 18:00:00	QQQ	ETF	44.15	44.17	44.14	44.16	26165.0

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

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