PREVIEW / etf_30min / 2007-12-11

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-12-11.parquet
  size:    152 KB
  rows:    5,451

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-12-11 04:00:00	SPY	ETF	152.46	152.46	152.46	152.46	100.0
2007-12-11 04:30:00	SPY	ETF	152.32	152.32	152.32	152.32	700.0
2007-12-11 05:00:00	SPY	ETF	152.31	152.31	152.12	152.12	1000.0
2007-12-11 06:00:00	SPY	ETF	151.98	152.01	151.98	152.01	10500.0
2007-12-11 06:30:00	SPY	ETF	152.07	152.37	152.07	152.37	21000.0
2007-12-11 07:00:00	SPY	ETF	152.29	152.29	152.08	152.08	36500.0
2007-12-11 07:30:00	SPY	ETF	152.15	152.52	152.14	152.31	122300.0
2007-12-11 08:00:00	SPY	ETF	152.29	152.43	152.26	152.26	297800.0
2007-12-11 08:30:00	SPY	ETF	152.25	152.32	152.15	152.2	171500.0
2007-12-11 09:00:00	SPY	ETF	152.2	152.29	152.1	152.14	403000.0
2007-12-11 09:30:00	SPY	ETF	152.14	152.3	151.97	152.09	8406410.0
2007-12-11 10:00:00	SPY	ETF	152.1	152.19	151.9	151.92	4914346.0
2007-12-11 10:30:00	SPY	ETF	151.92	151.95	151.68	151.705	7014800.0
2007-12-11 11:00:00	SPY	ETF	151.7	151.89	151.6	151.85	7561347.0
2007-12-11 11:30:00	SPY	ETF	151.85	151.88	151.7	151.82	2931099.0
2007-12-11 12:00:00	SPY	ETF	151.82	151.94	151.74	151.88	3152300.0
2007-12-11 12:30:00	SPY	ETF	151.878	152.2	151.87	152.18	3652100.0
2007-12-11 13:00:00	SPY	ETF	152.18	152.33	152.07	152.232	11416335.0
2007-12-11 13:30:00	SPY	ETF	152.24	152.58	152.16	152.5526	8476612.0
2007-12-11 14:00:00	SPY	ETF	152.56	152.89	149.65	150.21	50516215.0
2007-12-11 14:30:00	SPY	ETF	150.21	150.58	149.11	149.65	47712759.0
2007-12-11 15:00:00	SPY	ETF	149.65	149.65	148.62	148.95	33736627.0
2007-12-11 15:30:00	SPY	ETF	148.95	149.23	147.96	148.23	34951775.0
2007-12-11 16:00:00	SPY	ETF	148.11	151.9836	147.83	147.99	9744600.0
2007-12-11 16:30:00	SPY	ETF	147.99	148.36	147.78	147.85	7600300.0
2007-12-11 17:00:00	SPY	ETF	147.83	151.98	147.79	147.85	1615400.0
2007-12-11 17:30:00	SPY	ETF	147.84	147.96	147.78	147.96	121900.0
2007-12-11 18:00:00	SPY	ETF	147.96	148.2	147.96	148.14	184500.0
2007-12-11 18:30:00	SPY	ETF	148.15	148.36	148.11	148.3	74100.0
2007-12-11 19:00:00	SPY	ETF	148.27	148.44	148.27	148.4	38600.0
2007-12-11 19:30:00	SPY	ETF	148.4	148.48	148.4	148.47	32900.0
2007-12-11 05:30:00	QQQ	ETF	52.57	52.57	52.57	52.57	400.0
2007-12-11 06:00:00	QQQ	ETF	52.61	52.61	52.57	52.6	500.0
2007-12-11 06:30:00	QQQ	ETF	52.65	52.65	52.65	52.65	11500.0
2007-12-11 07:00:00	QQQ	ETF	52.65	52.66	52.59	52.62	73500.0
2007-12-11 07:30:00	QQQ	ETF	52.63	52.76	52.63	52.72	83454.0
2007-12-11 08:00:00	QQQ	ETF	52.7	52.72	52.67	52.67	361492.0
2007-12-11 08:30:00	QQQ	ETF	52.67	52.69	52.64	52.67	372279.0
2007-12-11 09:00:00	QQQ	ETF	52.66	52.68	52.56	52.61	2051833.0
2007-12-11 09:30:00	QQQ	ETF	52.61	52.69	52.56	52.63	6432089.0
2007-12-11 10:00:00	QQQ	ETF	52.64	52.7	52.61	52.64	3037201.0
2007-12-11 10:30:00	QQQ	ETF	52.63	52.64	52.58	52.58	3964818.0
2007-12-11 11:00:00	QQQ	ETF	52.59	52.65	52.54	52.63	3817546.0
2007-12-11 11:30:00	QQQ	ETF	52.63	52.65	52.58	52.635	2708278.0
2007-12-11 12:00:00	QQQ	ETF	52.63	52.64	52.6	52.6305	2000117.0
2007-12-11 12:30:00	QQQ	ETF	52.63	52.74	52.62	52.73	4554809.0
2007-12-11 13:00:00	QQQ	ETF	52.7319	52.8	52.7	52.77	3059763.0
2007-12-11 13:30:00	QQQ	ETF	52.77	52.84	52.72	52.84	5501026.0
2007-12-11 14:00:00	QQQ	ETF	52.84	52.84	51.88	52.11	43016794.0
2007-12-11 14:30:00	QQQ	ETF	52.11	52.13	51.52	51.82	37566865.0

> showing 50 of 5,451 rows — these rows as CSV

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