PREVIEW / etf_30min / 2008-12-18

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-12-18.parquet
  size:    195 KB
  rows:    6,818

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-12-18 04:30:00	SPY	ETF	91.39	91.44	91.33	91.4	5775.0
2008-12-18 05:00:00	SPY	ETF	91.49	91.52	91.33	91.33	400.0
2008-12-18 05:30:00	SPY	ETF	91.05	91.05	91.05	91.05	100.0
2008-12-18 06:00:00	SPY	ETF	91.25	91.4	91.25	91.4	710.0
2008-12-18 06:30:00	SPY	ETF	91.41	91.42	91.28	91.4	117400.0
2008-12-18 07:00:00	SPY	ETF	91.36	91.4	90.93	90.93	502025.0
2008-12-18 07:30:00	SPY	ETF	90.96	91.49	90.95	91.4	598087.0
2008-12-18 08:00:00	SPY	ETF	91.41	91.56	91.25	91.37	1301617.0
2008-12-18 08:30:00	SPY	ETF	91.37	91.81	91.28	91.6	2179978.0
2008-12-18 09:00:00	SPY	ETF	91.59	91.71	91.36	91.41	896790.0
2008-12-18 09:30:00	SPY	ETF	91.4	91.57	90.5	90.68	28871127.0
2008-12-18 10:00:00	SPY	ETF	90.69	91.33	90.67	91.16	22838378.0
2008-12-18 10:30:00	SPY	ETF	91.16	91.58	91.14	91.43	23841448.0
2008-12-18 11:00:00	SPY	ETF	91.44	91.67	90.85	91.05	20695389.0
2008-12-18 11:30:00	SPY	ETF	91.05	91.37	90.86	91.35	11785132.0
2008-12-18 12:00:00	SPY	ETF	91.35	91.42	90.9	90.92	20643674.0
2008-12-18 12:30:00	SPY	ETF	90.92	91.19	90.82	91.1192	10494615.0
2008-12-18 13:00:00	SPY	ETF	91.12	91.27	90.85	90.91	19053108.0
2008-12-18 13:30:00	SPY	ETF	90.92	91.1	90.29	90.35	20227985.0
2008-12-18 14:00:00	SPY	ETF	90.35	91.2	89.37	89.74	24875196.0
2008-12-18 14:30:00	SPY	ETF	89.74	91.2	89.52	89.93	27645175.0
2008-12-18 15:00:00	SPY	ETF	89.93	90.7	88.21	88.44	38078833.0
2008-12-18 15:30:00	SPY	ETF	88.45	89.5	88.34	89.15	55086955.0
2008-12-18 16:00:00	SPY	ETF	89.18	90.9624	88.9	89.82	19038674.0
2008-12-18 16:30:00	SPY	ETF	89.85	90.96	89.54	89.62	1557045.0
2008-12-18 17:00:00	SPY	ETF	89.64	89.72	89.56	89.71	18155330.0
2008-12-18 17:30:00	SPY	ETF	89.7	89.79	89.65	89.74	34691.0
2008-12-18 18:00:00	SPY	ETF	89.74	90.04	89.67	89.92	166339.0
2008-12-18 18:30:00	SPY	ETF	89.92	89.92	89.82	89.91	63999.0
2008-12-18 19:00:00	SPY	ETF	89.91	89.95	89.82	89.88	47622.0
2008-12-18 19:30:00	SPY	ETF	89.87	90.08	89.87	89.98	55950.0
2008-12-18 06:00:00	QQQ	ETF	30.36	30.36	30.36	30.36	500.0
2008-12-18 07:00:00	QQQ	ETF	30.3	30.3	30.16	30.17	16100.0
2008-12-18 07:30:00	QQQ	ETF	30.16	30.25	30.15	30.24	144710.0
2008-12-18 08:00:00	QQQ	ETF	30.24	30.28	30.19	30.25	770182.0
2008-12-18 08:30:00	QQQ	ETF	30.25	30.33	30.16	30.23	1423874.0
2008-12-18 09:00:00	QQQ	ETF	30.21	30.27	30.16	30.18	598267.0
2008-12-18 09:30:00	QQQ	ETF	30.19	30.36	29.99	30.11	13168241.0
2008-12-18 10:00:00	QQQ	ETF	30.11	30.31	30.11	30.26	13546249.0
2008-12-18 10:30:00	QQQ	ETF	30.26	30.4	30.24	30.3	7574894.0
2008-12-18 11:00:00	QQQ	ETF	30.2901	30.35	30.14	30.19	6759010.0
2008-12-18 11:30:00	QQQ	ETF	30.18	30.33	30.12	30.32	5167979.0
2008-12-18 12:00:00	QQQ	ETF	30.32	30.35	30.2	30.2	3943725.0
2008-12-18 12:30:00	QQQ	ETF	30.2	30.26	30.17	30.23	3469705.0
2008-12-18 13:00:00	QQQ	ETF	30.23	30.28	30.16	30.19	2749466.0
2008-12-18 13:30:00	QQQ	ETF	30.18	30.21	29.96	29.97	7815343.0
2008-12-18 14:00:00	QQQ	ETF	29.97	30.06	29.76	29.85	11677092.0
2008-12-18 14:30:00	QQQ	ETF	29.85	29.98	29.78	29.89	9617563.0
2008-12-18 15:00:00	QQQ	ETF	29.89	29.89	29.36	29.44	18594831.0
2008-12-18 15:30:00	QQQ	ETF	29.44	29.72	29.41	29.69	21182075.0

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

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