PREVIEW / etf_30min / 2009-11-09

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-11-09.parquet
  size:    238 KB
  rows:    7,950

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-11-09 04:00:00	SPY	ETF	107.83	107.9	107.81	107.9	5828.0
2009-11-09 04:30:00	SPY	ETF	107.88	108.1	107.88	108.08	8600.0
2009-11-09 05:00:00	SPY	ETF	108.02	108.02	108.02	108.02	100.0
2009-11-09 05:30:00	SPY	ETF	107.99	108.02	107.97	107.97	1000.0
2009-11-09 06:00:00	SPY	ETF	108.14	108.3	108.14	108.2	14552.0
2009-11-09 06:30:00	SPY	ETF	108.23	108.23	108.05	108.11	6815.0
2009-11-09 07:00:00	SPY	ETF	108.1	108.17	108.04	108.13	77103.0
2009-11-09 07:30:00	SPY	ETF	108.13	108.23	108.13	108.17	255379.0
2009-11-09 08:00:00	SPY	ETF	108.16	108.16	107.0	108.0	556112.0
2009-11-09 08:30:00	SPY	ETF	108.0	108.11	107.13	108.02	484273.0
2009-11-09 09:00:00	SPY	ETF	108.03	108.13	107.95	107.96	1015750.0
2009-11-09 09:30:00	SPY	ETF	107.95	108.33	107.87	108.26	23768803.0
2009-11-09 10:00:00	SPY	ETF	108.27	108.65	108.255	108.515	15708564.0
2009-11-09 10:30:00	SPY	ETF	108.5	108.7	108.45	108.65	9333251.0
2009-11-09 11:00:00	SPY	ETF	108.65	108.87	108.52	108.815	13225491.0
2009-11-09 11:30:00	SPY	ETF	108.82	108.91	108.74	108.795	6443395.0
2009-11-09 12:00:00	SPY	ETF	108.8	108.95	108.75	108.861	4750736.0
2009-11-09 12:30:00	SPY	ETF	108.87	108.99	108.82	108.99	5075975.0
2009-11-09 13:00:00	SPY	ETF	108.98	109.05	108.88	108.96	5893052.0
2009-11-09 13:30:00	SPY	ETF	108.96	109.22	108.92	109.17	7513666.0
2009-11-09 14:00:00	SPY	ETF	109.16	109.22	109.08	109.19	6834146.0
2009-11-09 14:30:00	SPY	ETF	109.18	109.41	109.18	109.35	8795469.0
2009-11-09 15:00:00	SPY	ETF	109.36	109.42	109.27	109.33	7515276.0
2009-11-09 15:30:00	SPY	ETF	109.33	109.62	109.19	109.58	24349412.0
2009-11-09 16:00:00	SPY	ETF	109.58	109.68	107.1653	109.61	8227610.0
2009-11-09 16:30:00	SPY	ETF	109.62	109.65	107.1653	109.59	1689812.0
2009-11-09 17:00:00	SPY	ETF	107.1653	109.6	107.1653	109.6	2216088.0
2009-11-09 17:30:00	SPY	ETF	109.58	109.58	108.09	109.55	5195856.0
2009-11-09 18:00:00	SPY	ETF	109.56	109.62	109.55	109.58	140658.0
2009-11-09 18:30:00	SPY	ETF	109.58	109.61	109.57	109.58	14373.0
2009-11-09 19:00:00	SPY	ETF	109.58	109.64	109.58	109.64	5050.0
2009-11-09 19:30:00	SPY	ETF	109.62	109.64	109.59	109.64	5605.0
2009-11-09 04:30:00	QQQ	ETF	42.9	42.94	42.9	42.94	200.0
2009-11-09 05:00:00	QQQ	ETF	42.89	42.89	42.89	42.89	100.0
2009-11-09 06:00:00	QQQ	ETF	42.97	43.02	42.97	43.01	15965.0
2009-11-09 06:30:00	QQQ	ETF	43.0	43.01	42.99	43.01	9500.0
2009-11-09 07:00:00	QQQ	ETF	42.99	42.99	42.96	42.98	16600.0
2009-11-09 07:30:00	QQQ	ETF	43.0	43.02	42.99	43.0	109268.0
2009-11-09 08:00:00	QQQ	ETF	43.0	43.02	41.5	42.99	493532.0
2009-11-09 08:30:00	QQQ	ETF	42.98	43.01	42.97	42.99	254025.0
2009-11-09 09:00:00	QQQ	ETF	42.99	43.03	42.9	42.92	834665.0
2009-11-09 09:30:00	QQQ	ETF	42.92	43.15	42.88	43.115	15237633.0
2009-11-09 10:00:00	QQQ	ETF	43.11	43.28	43.11	43.2	11993036.0
2009-11-09 10:30:00	QQQ	ETF	43.21	43.29	43.18	43.2682	4612075.0
2009-11-09 11:00:00	QQQ	ETF	43.27	43.33	43.16	43.27	9865570.0
2009-11-09 11:30:00	QQQ	ETF	43.26	43.32	43.235	43.27	3267259.0
2009-11-09 12:00:00	QQQ	ETF	43.2717	43.31	43.26	43.26	1649454.0
2009-11-09 12:30:00	QQQ	ETF	43.2685	43.34	43.25	43.31	3779123.0
2009-11-09 13:00:00	QQQ	ETF	43.31	43.36	43.28	43.3119	2645188.0
2009-11-09 13:30:00	QQQ	ETF	43.32	43.42	43.3	43.35	2859607.0

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

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