PREVIEW / etf_30min / 2009-06-22

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-06-22.parquet
  size:    226 KB
  rows:    7,503

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
2009-06-22 04:00:00	SPY	ETF	91.65	91.65	91.44	91.44	1350.0
2009-06-22 04:30:00	SPY	ETF	91.41	91.41	91.24	91.27	5400.0
2009-06-22 05:00:00	SPY	ETF	91.2	91.3	91.2	91.3	17700.0
2009-06-22 05:30:00	SPY	ETF	91.29	91.29	91.29	91.29	338.0
2009-06-22 06:00:00	SPY	ETF	91.42	91.42	91.22	91.27	14700.0
2009-06-22 06:30:00	SPY	ETF	91.35	91.44	91.19	91.29	31318.0
2009-06-22 07:00:00	SPY	ETF	91.28	91.39	91.15	91.15	346340.0
2009-06-22 07:30:00	SPY	ETF	91.14	91.35	91.13	91.23	302842.0
2009-06-22 08:00:00	SPY	ETF	91.23	91.32	91.11	91.15	1340166.0
2009-06-22 08:30:00	SPY	ETF	91.15	91.16	90.96	91.06	1508490.0
2009-06-22 09:00:00	SPY	ETF	91.06	91.18	90.99	91.12	1207345.0
2009-06-22 09:30:00	SPY	ETF	91.14	91.19	90.4	90.47	26881329.0
2009-06-22 10:00:00	SPY	ETF	90.47	90.62	90.3	90.4	22367716.0
2009-06-22 10:30:00	SPY	ETF	90.41	90.41	90.065	90.16	18700544.0
2009-06-22 11:00:00	SPY	ETF	90.1525	90.28	89.95	90.12	14080786.0
2009-06-22 11:30:00	SPY	ETF	90.12	90.16	89.68	89.73	15720809.0
2009-06-22 12:00:00	SPY	ETF	89.73	89.89	89.64	89.77	10334724.0
2009-06-22 12:30:00	SPY	ETF	89.78	89.9	89.67	89.805	8143492.0
2009-06-22 13:00:00	SPY	ETF	89.81	89.82	89.35	89.51	13376387.0
2009-06-22 13:30:00	SPY	ETF	89.51	89.78	89.5	89.74	7885975.0
2009-06-22 14:00:00	SPY	ETF	89.74	89.83	89.6	89.66	13127919.0
2009-06-22 14:30:00	SPY	ETF	89.66	89.89	89.57	89.78	14367829.0
2009-06-22 15:00:00	SPY	ETF	89.79	89.95	89.69	89.77	17459719.0
2009-06-22 15:30:00	SPY	ETF	89.77	89.96	89.26	89.26	34650606.0
2009-06-22 16:00:00	SPY	ETF	89.27	90.34	89.21	89.34	13153515.0
2009-06-22 16:30:00	SPY	ETF	89.33	89.38	89.25	89.37	464844.0
2009-06-22 17:00:00	SPY	ETF	89.37	89.38	89.29	89.34	147340.0
2009-06-22 17:30:00	SPY	ETF	89.34	89.38	89.34	89.35	39527.0
2009-06-22 18:00:00	SPY	ETF	89.34	89.36	89.27	89.32	4601735.0
2009-06-22 18:30:00	SPY	ETF	89.36	89.37	89.32	89.37	30804.0
2009-06-22 19:00:00	SPY	ETF	89.35	89.42	89.33	89.39	31780.0
2009-06-22 19:30:00	SPY	ETF	89.39	89.43	89.35	89.43	24700.0
2009-06-22 04:00:00	QQQ	ETF	35.88	35.88	35.85	35.85	600.0
2009-06-22 04:30:00	QQQ	ETF	35.82	35.82	35.77	35.77	600.0
2009-06-22 05:00:00	QQQ	ETF	35.75	35.75	35.75	35.75	400.0
2009-06-22 06:30:00	QQQ	ETF	35.76	35.76	35.75	35.75	500.0
2009-06-22 07:00:00	QQQ	ETF	35.76	35.85	35.74	35.76	552565.0
2009-06-22 07:30:00	QQQ	ETF	35.74	35.82	35.73	35.76	98579.0
2009-06-22 08:00:00	QQQ	ETF	35.78	35.81	35.73	35.73	828210.0
2009-06-22 08:30:00	QQQ	ETF	35.74	35.76	35.7	35.74	599650.0
2009-06-22 09:00:00	QQQ	ETF	35.73	35.81	35.72	35.8	534718.0
2009-06-22 09:30:00	QQQ	ETF	35.8	35.89	35.45	35.5	21100695.0
2009-06-22 10:00:00	QQQ	ETF	35.5	35.51	35.36	35.4	15282633.0
2009-06-22 10:30:00	QQQ	ETF	35.39	35.39	35.23	35.29	9571036.0
2009-06-22 11:00:00	QQQ	ETF	35.28	35.39	35.19	35.3226	8911144.0
2009-06-22 11:30:00	QQQ	ETF	35.32	35.35	35.14	35.16	6624651.0
2009-06-22 12:00:00	QQQ	ETF	35.165	35.22	35.09	35.13	7605829.0
2009-06-22 12:30:00	QQQ	ETF	35.14	35.18	35.1	35.15	2992127.0
2009-06-22 13:00:00	QQQ	ETF	35.15	35.16	35.02	35.07	7608549.0
2009-06-22 13:30:00	QQQ	ETF	35.069	35.17	35.06	35.16	4088934.0

> showing 50 of 7,503 rows — these rows as CSV

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