PREVIEW / etf_30min / 2008-08-21

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-08-21.parquet
  size:    165 KB
  rows:    5,821

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-08-21 04:00:00	SPY	ETF	126.81	126.92	126.81	126.92	30600.0
2008-08-21 04:30:00	SPY	ETF	126.95	127.14	126.95	127.14	1500.0
2008-08-21 06:00:00	SPY	ETF	127.0	127.11	127.0	127.0	96200.0
2008-08-21 06:30:00	SPY	ETF	127.0	127.19	127.0	127.1	83500.0
2008-08-21 07:00:00	SPY	ETF	127.05	127.23	127.05	127.16	133837.0
2008-08-21 07:30:00	SPY	ETF	127.16	127.21	126.87	126.9	612656.0
2008-08-21 08:00:00	SPY	ETF	126.9	127.19	126.89	126.99	1592921.0
2008-08-21 08:30:00	SPY	ETF	127.01	127.24	126.7	126.77	1591483.0
2008-08-21 09:00:00	SPY	ETF	126.77	126.86	126.64	126.74	1379525.0
2008-08-21 09:30:00	SPY	ETF	126.75	127.42	126.6	127.28	20642499.0
2008-08-21 10:00:00	SPY	ETF	127.28	127.63	127.0	127.4	20374534.0
2008-08-21 10:30:00	SPY	ETF	127.39	127.42	126.84	127.15	18158278.0
2008-08-21 11:00:00	SPY	ETF	127.15	127.31	126.84	127.26	12480394.0
2008-08-21 11:30:00	SPY	ETF	127.26	127.64	127.1	127.42	11192943.0
2008-08-21 12:00:00	SPY	ETF	127.42	127.69	127.23	127.335	9400251.0
2008-08-21 12:30:00	SPY	ETF	127.34	127.45	127.27	127.42	6048675.0
2008-08-21 13:00:00	SPY	ETF	127.41	127.85	127.4	127.6381	11202277.0
2008-08-21 13:30:00	SPY	ETF	127.64	127.88	127.46	127.61	7059397.0
2008-08-21 14:00:00	SPY	ETF	127.61	127.96	127.52	127.84	8143725.0
2008-08-21 14:30:00	SPY	ETF	127.85	128.36	127.84	128.15	14898544.0
2008-08-21 15:00:00	SPY	ETF	128.15	128.44	128.07	128.14	12776582.0
2008-08-21 15:30:00	SPY	ETF	128.1495	128.35	127.94	127.99	18148220.0
2008-08-21 16:00:00	SPY	ETF	127.96	128.0	127.81	127.84	1628308.0
2008-08-21 16:30:00	SPY	ETF	127.83	128.2	127.8	127.8	1653842.0
2008-08-21 17:00:00	SPY	ETF	127.86	127.86	127.79	127.8	25538.0
2008-08-21 17:30:00	SPY	ETF	127.79	127.82	126.82	127.8	31846.0
2008-08-21 18:00:00	SPY	ETF	127.79	127.89	127.76	127.77	116228.0
2008-08-21 18:30:00	SPY	ETF	127.81	127.81	127.76	127.78	3552.0
2008-08-21 19:00:00	SPY	ETF	127.78	127.83	127.78	127.78	5600.0
2008-08-21 19:30:00	SPY	ETF	127.8	127.81	127.75	127.81	2803.0
2008-08-21 04:00:00	QQQ	ETF	46.77	46.77	46.77	46.77	200.0
2008-08-21 05:30:00	QQQ	ETF	46.74	46.77	46.73	46.77	10200.0
2008-08-21 06:00:00	QQQ	ETF	46.79	46.8	46.79	46.8	5000.0
2008-08-21 06:30:00	QQQ	ETF	46.8	46.84	46.8	46.83	8500.0
2008-08-21 07:00:00	QQQ	ETF	46.81	46.91	46.8	46.88	201599.0
2008-08-21 07:30:00	QQQ	ETF	46.89	46.92	46.74	46.79	134504.0
2008-08-21 08:00:00	QQQ	ETF	46.79	46.87	46.78	46.81	597434.0
2008-08-21 08:30:00	QQQ	ETF	46.82	46.93	46.72	46.74	482606.0
2008-08-21 09:00:00	QQQ	ETF	46.74	46.77	46.67	46.72	1172561.0
2008-08-21 09:30:00	QQQ	ETF	46.73	46.92	46.63	46.87	19071381.0
2008-08-21 10:00:00	QQQ	ETF	46.87	46.97	46.69	46.75	14001935.0
2008-08-21 10:30:00	QQQ	ETF	46.755	46.77	46.38	46.53	16575354.0
2008-08-21 11:00:00	QQQ	ETF	46.53	46.63	46.39	46.62	9620064.0
2008-08-21 11:30:00	QQQ	ETF	46.625	46.72	46.5	46.65	6334382.0
2008-08-21 12:00:00	QQQ	ETF	46.66	46.78	46.55	46.57	5153676.0
2008-08-21 12:30:00	QQQ	ETF	46.56	46.62	46.55	46.57	2075732.0
2008-08-21 13:00:00	QQQ	ETF	46.57	46.78	46.56	46.69	6126549.0
2008-08-21 13:30:00	QQQ	ETF	46.7	46.86	46.67	46.771	4553850.0
2008-08-21 14:00:00	QQQ	ETF	46.77	46.98	46.74	46.92	4937947.0
2008-08-21 14:30:00	QQQ	ETF	46.93	47.08	46.89	46.91	6872572.0

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

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