PREVIEW / etf_30min / 2008-07-23

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-07-23.parquet
  size:    179 KB
  rows:    6,142

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
2008-07-23 04:00:00	SPY	ETF	127.97	127.97	127.97	127.97	1000.0
2008-07-23 04:30:00	SPY	ETF	128.22	128.25	128.21	128.25	147100.0
2008-07-23 05:30:00	SPY	ETF	128.13	128.15	128.13	128.15	8000.0
2008-07-23 06:00:00	SPY	ETF	128.2	128.25	128.11	128.18	107400.0
2008-07-23 06:30:00	SPY	ETF	128.14	128.2	128.04	128.08	50300.0
2008-07-23 07:00:00	SPY	ETF	127.99	128.18	127.99	128.18	594997.0
2008-07-23 07:30:00	SPY	ETF	128.18	128.18	127.88	128.1	579851.0
2008-07-23 08:00:00	SPY	ETF	128.07	128.28	127.94	128.23	1546544.0
2008-07-23 08:30:00	SPY	ETF	128.19	128.25	127.97	128.02	1552517.0
2008-07-23 09:00:00	SPY	ETF	128.03	128.25	127.55	127.9	3184901.0
2008-07-23 09:30:00	SPY	ETF	127.89	128.15	127.55	127.88	33223171.0
2008-07-23 10:00:00	SPY	ETF	127.88	128.91	127.75	128.64	32338756.0
2008-07-23 10:30:00	SPY	ETF	128.64	129.15	128.54	128.57	37377682.0
2008-07-23 11:00:00	SPY	ETF	128.57	128.71	128.28	128.61	24388184.0
2008-07-23 11:30:00	SPY	ETF	128.61	128.649	128.02	128.1	17736260.0
2008-07-23 12:00:00	SPY	ETF	128.1	128.3	127.7	128.01	25125152.0
2008-07-23 12:30:00	SPY	ETF	128.0	128.29	127.78	128.2	12502343.0
2008-07-23 13:00:00	SPY	ETF	128.2	128.29	127.89	128.0556	7331895.0
2008-07-23 13:30:00	SPY	ETF	128.06	128.5	127.65	127.9	21096176.0
2008-07-23 14:00:00	SPY	ETF	127.9	128.55	127.83	128.5	21964793.0
2008-07-23 14:30:00	SPY	ETF	128.51	128.68	128.07	128.18	17214945.0
2008-07-23 15:00:00	SPY	ETF	128.17	129.06	127.96	128.09	15907067.0
2008-07-23 15:30:00	SPY	ETF	128.09	128.81	127.86	128.22	21046792.0
2008-07-23 16:00:00	SPY	ETF	128.25	128.4847	127.6987	127.6987	5756259.0
2008-07-23 16:30:00	SPY	ETF	128.16	128.23	127.6987	128.1	4801656.0
2008-07-23 17:00:00	SPY	ETF	128.1	128.18	128.07	128.18	108177.0
2008-07-23 17:30:00	SPY	ETF	128.17	128.24	128.17	128.22	3528342.0
2008-07-23 18:00:00	SPY	ETF	128.19	128.25	128.17	128.24	25749.0
2008-07-23 18:30:00	SPY	ETF	128.24	128.34	128.22	128.34	11190.0
2008-07-23 19:00:00	SPY	ETF	128.31	128.31	128.28	128.28	3238.0
2008-07-23 19:30:00	SPY	ETF	128.29	128.35	128.2	128.25	21041.0
2008-07-23 04:00:00	QQQ	ETF	44.72	44.72	44.72	44.72	300.0
2008-07-23 04:30:00	QQQ	ETF	45.02	45.13	45.02	45.11	3000.0
2008-07-23 05:00:00	QQQ	ETF	45.03	45.1	45.03	45.1	300.0
2008-07-23 05:30:00	QQQ	ETF	45.05	45.05	45.04	45.05	2700.0
2008-07-23 06:00:00	QQQ	ETF	45.06	45.08	45.06	45.08	1200.0
2008-07-23 06:30:00	QQQ	ETF	45.02	45.06	45.02	45.03	3800.0
2008-07-23 07:00:00	QQQ	ETF	45.01	45.04	44.99	45.04	359220.0
2008-07-23 07:30:00	QQQ	ETF	45.04	45.04	44.94	45.03	430730.0
2008-07-23 08:00:00	QQQ	ETF	45.02	45.06	44.98	45.03	994436.0
2008-07-23 08:30:00	QQQ	ETF	45.04	45.04	44.93	44.94	612573.0
2008-07-23 09:00:00	QQQ	ETF	44.94	45.07	44.84	44.84	807972.0
2008-07-23 09:30:00	QQQ	ETF	44.84	45.05	44.72	45.01	20151110.0
2008-07-23 10:00:00	QQQ	ETF	45.01	45.65	44.94	45.51	25487130.0
2008-07-23 10:30:00	QQQ	ETF	45.51	45.89	45.5	45.51	21426176.0
2008-07-23 11:00:00	QQQ	ETF	45.51	45.55	45.35	45.51	8287063.0
2008-07-23 11:30:00	QQQ	ETF	45.5	45.53	45.1305	45.16	9480763.0
2008-07-23 12:00:00	QQQ	ETF	45.1619	45.28	44.84	44.97	11118801.0
2008-07-23 12:30:00	QQQ	ETF	44.97	45.1	44.86	45.08	5473243.0
2008-07-23 13:00:00	QQQ	ETF	45.08	45.5	44.96	45.08	4238276.0

> showing 50 of 6,142 rows — these rows as CSV

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