PREVIEW / etf_30min / 2008-10-28

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-10-28.parquet
  size:    178 KB
  rows:    6,456

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-10-28 04:00:00	SPY	ETF	87.71	87.96	87.55	87.55	3500.0
2008-10-28 04:30:00	SPY	ETF	87.71	87.93	86.5	86.5	5100.0
2008-10-28 05:00:00	SPY	ETF	86.7	87.25	86.7	87.25	32500.0
2008-10-28 05:30:00	SPY	ETF	86.97	87.3	86.71	87.15	66100.0
2008-10-28 06:00:00	SPY	ETF	87.09	87.3	86.95	87.15	366200.0
2008-10-28 06:30:00	SPY	ETF	87.05	87.1	86.7	86.95	107900.0
2008-10-28 07:00:00	SPY	ETF	86.88	87.64	86.84	87.31	878992.0
2008-10-28 07:30:00	SPY	ETF	87.3	88.04	87.1	87.78	1459323.0
2008-10-28 08:00:00	SPY	ETF	87.78	87.91	84.0	87.54	1831200.0
2008-10-28 08:30:00	SPY	ETF	87.5	87.57	87.06	87.36	1659289.0
2008-10-28 09:00:00	SPY	ETF	87.36	87.52	86.84	87.37	3792028.0
2008-10-28 09:30:00	SPY	ETF	87.34	88.31	86.93	87.7	49856825.0
2008-10-28 10:00:00	SPY	ETF	87.86	87.91	86.36	86.48	51872990.0
2008-10-28 10:30:00	SPY	ETF	86.48	87.08	84.53	84.85	37763647.0
2008-10-28 11:00:00	SPY	ETF	84.85	85.91	84.81	85.69	90114327.0
2008-10-28 11:30:00	SPY	ETF	85.69	86.68	85.64	85.94	25366931.0
2008-10-28 12:00:00	SPY	ETF	85.93	86.47	85.62	86.01	15905807.0
2008-10-28 12:30:00	SPY	ETF	86.03	87.0	85.92	86.83	16978989.0
2008-10-28 13:00:00	SPY	ETF	86.84	87.71	86.6675	87.11	39956452.0
2008-10-28 13:30:00	SPY	ETF	87.11	87.22	84.95	86.25	17707939.0
2008-10-28 14:00:00	SPY	ETF	86.24	87.94	86.19	87.81	24630510.0
2008-10-28 14:30:00	SPY	ETF	87.82	90.06	87.8	89.62	53472294.0
2008-10-28 15:00:00	SPY	ETF	89.62	91.29	86.84	91.04	63597287.0
2008-10-28 15:30:00	SPY	ETF	91.04	94.2	87.48	94.0	96648983.0
2008-10-28 16:00:00	SPY	ETF	94.01	94.24	84.8968	93.81	28072471.0
2008-10-28 16:30:00	SPY	ETF	93.81	94.083	84.9599	93.35	10725870.0
2008-10-28 17:00:00	SPY	ETF	93.35	94.083	87.64	93.63	4886499.0
2008-10-28 17:30:00	SPY	ETF	93.57	93.73	93.51	93.68	73221.0
2008-10-28 18:00:00	SPY	ETF	93.67	93.73	92.95	93.09	326115.0
2008-10-28 18:30:00	SPY	ETF	93.14	93.34	93.06	93.33	91665.0
2008-10-28 19:00:00	SPY	ETF	93.31	93.59	93.25	93.26	58637.0
2008-10-28 19:30:00	SPY	ETF	93.29	93.65	93.24	93.48	51693.0
2008-10-28 04:00:00	QQQ	ETF	29.82	29.9	29.8	29.9	5500.0
2008-10-28 04:30:00	QQQ	ETF	29.71	29.88	29.41	29.41	1300.0
2008-10-28 05:00:00	QQQ	ETF	29.38	29.8	29.38	29.7	5800.0
2008-10-28 05:30:00	QQQ	ETF	29.75	29.75	29.75	29.75	200.0
2008-10-28 06:00:00	QQQ	ETF	29.73	29.85	29.67	29.67	2500.0
2008-10-28 06:30:00	QQQ	ETF	29.71	29.71	29.57	29.62	5800.0
2008-10-28 07:00:00	QQQ	ETF	29.57	29.92	29.53	29.8	466639.0
2008-10-28 07:30:00	QQQ	ETF	29.8	30.0	29.71	29.98	586597.0
2008-10-28 08:00:00	QQQ	ETF	29.98	29.98	29.2	29.83	944307.0
2008-10-28 08:30:00	QQQ	ETF	29.82	29.84	29.62	29.73	1045625.0
2008-10-28 09:00:00	QQQ	ETF	29.74	29.81	29.56	29.68	990256.0
2008-10-28 09:30:00	QQQ	ETF	29.68	29.99	29.48	29.82	26934093.0
2008-10-28 10:00:00	QQQ	ETF	29.82	29.84	29.36	29.41	35198954.0
2008-10-28 10:30:00	QQQ	ETF	29.4	29.48	28.85	28.95	23858755.0
2008-10-28 11:00:00	QQQ	ETF	28.94	29.26	28.94	29.18	21103955.0
2008-10-28 11:30:00	QQQ	ETF	29.17	29.47	29.16	29.23	13554150.0
2008-10-28 12:00:00	QQQ	ETF	29.22	29.36	29.1	29.209	9129625.0
2008-10-28 12:30:00	QQQ	ETF	29.21	29.51	29.19	29.4	10292676.0

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

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