PREVIEW / etf_30min / 2007-07-27

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-07-27.parquet
  size:    140 KB
  rows:    5,121

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-07-27 04:00:00	SPY	ETF	148.4	148.52	148.2	148.52	19600.0
2007-07-27 04:30:00	SPY	ETF	148.52	148.84	148.52	148.72	9300.0
2007-07-27 05:00:00	SPY	ETF	148.75	148.75	148.6	148.6	2000.0
2007-07-27 05:30:00	SPY	ETF	148.4	148.4	148.4	148.4	5000.0
2007-07-27 06:00:00	SPY	ETF	148.17	148.17	148.17	148.17	600.0
2007-07-27 06:30:00	SPY	ETF	148.38	148.48	147.99	148.08	114200.0
2007-07-27 07:00:00	SPY	ETF	148.1	148.1	146.98	147.03	3656600.0
2007-07-27 07:30:00	SPY	ETF	147.03	147.42	146.92	147.07	2442100.0
2007-07-27 08:00:00	SPY	ETF	147.33	148.12	146.93	147.15	9079100.0
2007-07-27 08:30:00	SPY	ETF	147.19	148.47	147.03	147.69	14464600.0
2007-07-27 09:00:00	SPY	ETF	147.65	148.26	147.65	148.26	5446300.0
2007-07-27 09:30:00	SPY	ETF	148.21	148.4399	147.17	148.08	38437100.0
2007-07-27 10:00:00	SPY	ETF	148.08	148.87	147.68	148.36	36668359.0
2007-07-27 10:30:00	SPY	ETF	148.35	148.65	146.57	147.53	29055936.0
2007-07-27 11:00:00	SPY	ETF	147.53	148.01	147.32	147.45	20328653.0
2007-07-27 11:30:00	SPY	ETF	147.44	147.65	146.43	146.76	24076677.0
2007-07-27 12:00:00	SPY	ETF	146.76	147.0	146.31	146.86	29477178.0
2007-07-27 12:30:00	SPY	ETF	146.86	147.2	146.12	146.77	26403432.0
2007-07-27 13:00:00	SPY	ETF	146.77	147.55	146.57	147.1701	20797701.0
2007-07-27 13:30:00	SPY	ETF	147.17	147.9	146.86	147.66	18370547.0
2007-07-27 14:00:00	SPY	ETF	147.67	147.87	146.86	147.01	16988071.0
2007-07-27 14:30:00	SPY	ETF	147.0	148.14	146.93	147.84	21250509.0
2007-07-27 15:00:00	SPY	ETF	147.84	147.98	146.71	147.51	21482124.0
2007-07-27 15:30:00	SPY	ETF	147.51	147.62	145.24	146.04	44519941.0
2007-07-27 16:00:00	SPY	ETF	145.8	146.18	144.95	145.1	8921200.0
2007-07-27 16:30:00	SPY	ETF	145.1	146.7	145.05	145.36	18882100.0
2007-07-27 17:00:00	SPY	ETF	145.34	145.35	145.16	145.25	199800.0
2007-07-27 17:30:00	SPY	ETF	145.23	145.55	145.2	145.4	252600.0
2007-07-27 18:00:00	SPY	ETF	145.38	145.44	145.13	145.14	100900.0
2007-07-27 18:30:00	SPY	ETF	145.14	145.2	145.14	145.2	52200.0
2007-07-27 19:00:00	SPY	ETF	145.3	145.39	145.13	145.13	19600.0
2007-07-27 19:30:00	SPY	ETF	145.16	147.7105	145.16	145.25	18100.0
2007-07-27 07:00:00	QQQ	ETF	48.74	48.75	48.52	48.54	296294.0
2007-07-27 07:30:00	QQQ	ETF	48.54	48.66	48.51	48.55	370168.0
2007-07-27 08:00:00	QQQ	ETF	48.57	48.7	48.54	48.7	970144.0
2007-07-27 08:30:00	QQQ	ETF	48.7	48.93	48.6	48.79	3738151.0
2007-07-27 09:00:00	QQQ	ETF	48.78	48.95	48.78	48.91	1397215.0
2007-07-27 09:30:00	QQQ	ETF	48.89	48.95	48.49	48.86	29893414.0
2007-07-27 10:00:00	QQQ	ETF	48.8505	49.12	48.77	48.97	28043985.0
2007-07-27 10:30:00	QQQ	ETF	48.96	49.05	48.58	48.7294	18297033.0
2007-07-27 11:00:00	QQQ	ETF	48.73	48.9	48.64	48.67	17606082.0
2007-07-27 11:30:00	QQQ	ETF	48.67	48.7	48.43	48.49	11044833.0
2007-07-27 12:00:00	QQQ	ETF	48.5085	48.57	48.41	48.48	11394806.0
2007-07-27 12:30:00	QQQ	ETF	48.4815	48.53	48.14	48.29	31993879.0
2007-07-27 13:00:00	QQQ	ETF	48.29	48.53	48.2574	48.39	16305698.0
2007-07-27 13:30:00	QQQ	ETF	48.39	48.64	48.27	48.56	10508416.0
2007-07-27 14:00:00	QQQ	ETF	48.56	48.63	48.35	48.4	12292447.0
2007-07-27 14:30:00	QQQ	ETF	48.4	48.79	48.37	48.65	11537760.0
2007-07-27 15:00:00	QQQ	ETF	48.65	48.7	48.52	48.61	7616227.0
2007-07-27 15:30:00	QQQ	ETF	48.62	48.66	48.08	48.09	22494474.0

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

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