PREVIEW / etf_30min / 2007-09-12

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-09-12.parquet
  size:    121 KB
  rows:    4,559

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-09-12 04:00:00	SPY	ETF	147.36	147.36	147.36	147.36	100.0
2007-09-12 05:00:00	SPY	ETF	147.13	147.13	147.08	147.08	10000.0
2007-09-12 05:30:00	SPY	ETF	147.12	147.13	147.12	147.13	17500.0
2007-09-12 06:30:00	SPY	ETF	147.25	147.25	147.25	147.25	2500.0
2007-09-12 07:00:00	SPY	ETF	147.33	147.33	146.97	147.01	385000.0
2007-09-12 07:30:00	SPY	ETF	147.08	147.11	146.96	147.02	192100.0
2007-09-12 08:00:00	SPY	ETF	147.03	147.1	146.91	147.1	768500.0
2007-09-12 08:30:00	SPY	ETF	147.1	147.49	147.05	147.19	316400.0
2007-09-12 09:00:00	SPY	ETF	147.12	147.31	147.07	147.28	414667.0
2007-09-12 09:30:00	SPY	ETF	147.29	147.73	146.98	147.65	20144846.0
2007-09-12 10:00:00	SPY	ETF	147.65	147.8	147.32	147.76	10710800.0
2007-09-12 10:30:00	SPY	ETF	147.76	148.02	147.57	147.64	18277700.0
2007-09-12 11:00:00	SPY	ETF	147.64	148.21	147.56	148.05	10117600.0
2007-09-12 11:30:00	SPY	ETF	148.06	148.16	147.86	147.95	11678000.0
2007-09-12 12:00:00	SPY	ETF	147.95	148.18	147.63	147.71	6357100.0
2007-09-12 12:30:00	SPY	ETF	147.71	147.95	147.58	147.81	5493800.0
2007-09-12 13:00:00	SPY	ETF	147.81	147.81	147.45	147.67	6751800.0
2007-09-12 13:30:00	SPY	ETF	147.67	148.15	147.51	147.99	7836700.0
2007-09-12 14:00:00	SPY	ETF	147.99	148.44	147.85	148.07	7562800.0
2007-09-12 14:30:00	SPY	ETF	148.07	148.24	147.92	148.21	8192300.0
2007-09-12 15:00:00	SPY	ETF	148.21	148.22	147.62	147.64	9868000.0
2007-09-12 15:30:00	SPY	ETF	147.64	147.95	147.48	147.64	18950000.0
2007-09-12 16:00:00	SPY	ETF	147.65	147.9884	147.5994	147.8	3475700.0
2007-09-12 16:30:00	SPY	ETF	147.85	147.95	147.8	147.91	157600.0
2007-09-12 17:00:00	SPY	ETF	147.93	147.94	147.73	147.77	98400.0
2007-09-12 17:30:00	SPY	ETF	147.83	147.9	147.83	147.84	5300.0
2007-09-12 18:00:00	SPY	ETF	147.84	147.84	147.76	147.83	12800.0
2007-09-12 18:30:00	SPY	ETF	147.81	147.81	147.78	147.81	900.0
2007-09-12 19:00:00	SPY	ETF	147.81	147.83	147.81	147.83	3400.0
2007-09-12 19:30:00	SPY	ETF	147.79	147.79	147.7	147.71	9900.0
2007-09-12 06:30:00	QQQ	ETF	48.86	48.88	48.86	48.86	10300.0
2007-09-12 07:00:00	QQQ	ETF	48.83	48.85	48.73	48.75	526536.0
2007-09-12 07:30:00	QQQ	ETF	48.78	48.8	48.72	48.79	170683.0
2007-09-12 08:00:00	QQQ	ETF	48.79	48.81	48.74	48.8	706965.0
2007-09-12 08:30:00	QQQ	ETF	48.81	48.85	48.75	48.77	222280.0
2007-09-12 09:00:00	QQQ	ETF	48.75	48.85	48.75	48.85	382551.0
2007-09-12 09:30:00	QQQ	ETF	48.84	49.09	48.78	49.08	12189225.0
2007-09-12 10:00:00	QQQ	ETF	49.0775	49.14	48.99	49.1195	7676740.0
2007-09-12 10:30:00	QQQ	ETF	49.12	49.23	49.01	49.14	5873420.0
2007-09-12 11:00:00	QQQ	ETF	49.13	49.37	49.1	49.301	7518561.0
2007-09-12 11:30:00	QQQ	ETF	49.3	49.32	49.24	49.27	3142454.0
2007-09-12 12:00:00	QQQ	ETF	49.26	49.33	49.12	49.15	4605192.0
2007-09-12 12:30:00	QQQ	ETF	49.14	49.2	49.1	49.16	3072322.0
2007-09-12 13:00:00	QQQ	ETF	49.15	49.16	49.01	49.09	3988716.0
2007-09-12 13:30:00	QQQ	ETF	49.09	49.24	49.039	49.19	5704319.0
2007-09-12 14:00:00	QQQ	ETF	49.19	49.31	49.15	49.16	4982222.0
2007-09-12 14:30:00	QQQ	ETF	49.1585	49.21	49.08	49.16	3520963.0
2007-09-12 15:00:00	QQQ	ETF	49.16	49.17	48.95	48.951	6460048.0
2007-09-12 15:30:00	QQQ	ETF	48.9515	49.02	48.87	48.93	10339398.0
2007-09-12 16:00:00	QQQ	ETF	48.93	49.07	48.92	49.04	1339649.0

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

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