PREVIEW / etf_30min / 2007-09-07

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-09-07.parquet
  size:    127 KB
  rows:    4,743

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-07 04:00:00	SPY	ETF	148.0	148.0	148.0	148.0	100.0
2007-09-07 05:00:00	SPY	ETF	147.56	147.56	147.56	147.56	1000.0
2007-09-07 06:00:00	SPY	ETF	147.61	147.61	147.48	147.61	38500.0
2007-09-07 06:30:00	SPY	ETF	147.58	147.76	147.57	147.6	15100.0
2007-09-07 07:00:00	SPY	ETF	147.57	147.75	147.52	147.63	145400.0
2007-09-07 07:30:00	SPY	ETF	147.63	147.85	147.55	147.82	487000.0
2007-09-07 08:00:00	SPY	ETF	147.59	147.9	147.59	147.77	2102200.0
2007-09-07 08:30:00	SPY	ETF	147.72	147.9	146.6	146.67	13729400.0
2007-09-07 09:00:00	SPY	ETF	146.65	146.83	146.33	146.49	6620513.0
2007-09-07 09:30:00	SPY	ETF	146.48	146.72	146.16	146.51	20090566.0
2007-09-07 10:00:00	SPY	ETF	146.5	146.83	146.27	146.52	13937300.0
2007-09-07 10:30:00	SPY	ETF	146.52	146.55	145.82	145.91	23043899.0
2007-09-07 11:00:00	SPY	ETF	145.92	146.07	145.6	145.67	12107100.0
2007-09-07 11:30:00	SPY	ETF	145.66	146.47	145.63	146.38	13703200.0
2007-09-07 12:00:00	SPY	ETF	146.38	146.45	146.06	146.44	9867700.0
2007-09-07 12:30:00	SPY	ETF	146.44	146.62	146.22	146.44	9926000.0
2007-09-07 13:00:00	SPY	ETF	146.44	146.89	146.38	146.55	13062200.0
2007-09-07 13:30:00	SPY	ETF	146.54	146.69	146.05	146.14	8343500.0
2007-09-07 14:00:00	SPY	ETF	146.14	146.34	145.93	146.121	8059500.0
2007-09-07 14:30:00	SPY	ETF	146.12	146.21	145.5	145.56	16254800.0
2007-09-07 15:00:00	SPY	ETF	145.56	146.03	145.33	145.44	21466100.0
2007-09-07 15:30:00	SPY	ETF	145.4416	146.1	145.26	145.84	33363300.0
2007-09-07 16:00:00	SPY	ETF	145.9	146.5656	145.78	146.07	4635700.0
2007-09-07 16:30:00	SPY	ETF	146.07	146.2	146.07	146.15	189700.0
2007-09-07 17:00:00	SPY	ETF	146.15	146.18	145.84	145.96	1566700.0
2007-09-07 17:30:00	SPY	ETF	145.9	146.0	145.85	146.0	6700.0
2007-09-07 18:00:00	SPY	ETF	145.88	146.0	145.88	146.0	1500.0
2007-09-07 18:30:00	SPY	ETF	145.96	146.2	145.96	146.2	17800.0
2007-09-07 19:00:00	SPY	ETF	146.2	146.25	146.17	146.25	2300.0
2007-09-07 19:30:00	SPY	ETF	146.19	146.19	146.19	146.19	100.0
2007-09-07 07:00:00	QQQ	ETF	48.92	48.95	48.91	48.95	10200.0
2007-09-07 07:30:00	QQQ	ETF	48.95	48.96	48.92	48.92	27796.0
2007-09-07 08:00:00	QQQ	ETF	48.99	49.02	48.94	48.97	461118.0
2007-09-07 08:30:00	QQQ	ETF	48.97	49.25	48.66	48.66	9443329.0
2007-09-07 09:00:00	QQQ	ETF	48.65	48.67	48.49	48.53	2146297.0
2007-09-07 09:30:00	QQQ	ETF	48.53	48.6	48.36	48.511	13159477.0
2007-09-07 10:00:00	QQQ	ETF	48.51	48.59	48.4	48.45	9178052.0
2007-09-07 10:30:00	QQQ	ETF	48.45	48.46	48.04	48.081	17028618.0
2007-09-07 11:00:00	QQQ	ETF	48.0895	48.17	48.0	48.01	8620213.0
2007-09-07 11:30:00	QQQ	ETF	48.02	48.33	47.99	48.33	11747664.0
2007-09-07 12:00:00	QQQ	ETF	48.33	48.34	48.18	48.33	5156330.0
2007-09-07 12:30:00	QQQ	ETF	48.33	48.37	48.2	48.27	6124880.0
2007-09-07 13:00:00	QQQ	ETF	48.2785	48.4	48.25	48.299	6799276.0
2007-09-07 13:30:00	QQQ	ETF	48.3	48.35	48.15	48.17	3921897.0
2007-09-07 14:00:00	QQQ	ETF	48.17	48.25	48.1	48.19	5380154.0
2007-09-07 14:30:00	QQQ	ETF	48.2	48.22	48.01	48.02	6133294.0
2007-09-07 15:00:00	QQQ	ETF	48.01	48.18	47.98	48.02	8836740.0
2007-09-07 15:30:00	QQQ	ETF	48.03	48.23	47.95	48.23	18726748.0
2007-09-07 16:00:00	QQQ	ETF	48.23	48.38	48.1414	48.33	4243472.0
2007-09-07 16:30:00	QQQ	ETF	48.33	48.36	48.32	48.34	40839.0

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

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