PREVIEW / etf_30min / 2010-01-07

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-01-07.parquet
  size:    242 KB
  rows:    8,147

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
2010-01-07 04:00:00	SPY	ETF	113.43	113.43	113.43	113.43	100.0
2010-01-07 04:30:00	SPY	ETF	113.38	113.38	113.2	113.2	663.0
2010-01-07 05:00:00	SPY	ETF	113.21	113.21	113.2	113.2	200.0
2010-01-07 05:30:00	SPY	ETF	113.3	113.3	113.28	113.29	30200.0
2010-01-07 06:00:00	SPY	ETF	113.29	113.36	113.25	113.36	11400.0
2010-01-07 07:00:00	SPY	ETF	113.35	113.43	113.3	113.4	58450.0
2010-01-07 07:30:00	SPY	ETF	113.4	113.41	113.28	113.31	862330.0
2010-01-07 08:00:00	SPY	ETF	113.31	113.73	113.31	113.39	3349140.0
2010-01-07 08:30:00	SPY	ETF	113.39	113.54	113.34	113.48	1330690.0
2010-01-07 09:00:00	SPY	ETF	113.49	113.55	113.45	113.51	654274.0
2010-01-07 09:30:00	SPY	ETF	113.5	113.69	113.18	113.24	16253145.0
2010-01-07 10:00:00	SPY	ETF	113.2	113.49	113.2	113.47	7459542.0
2010-01-07 10:30:00	SPY	ETF	113.47	113.92	113.42	113.81	13582737.0
2010-01-07 11:00:00	SPY	ETF	113.81	113.87	113.77	113.77	4844546.0
2010-01-07 11:30:00	SPY	ETF	113.78	113.84	113.558	113.78	6068500.0
2010-01-07 12:00:00	SPY	ETF	113.78	113.975	113.75	113.87	6076602.0
2010-01-07 12:30:00	SPY	ETF	113.87	114.03	113.84	113.87	5900888.0
2010-01-07 13:00:00	SPY	ETF	113.88	113.96	113.78	113.93	2851687.0
2010-01-07 13:30:00	SPY	ETF	113.93	114.01	113.88	113.92	3910678.0
2010-01-07 14:00:00	SPY	ETF	113.92	114.05	113.89	114.04	4645035.0
2010-01-07 14:30:00	SPY	ETF	114.04	114.3	113.7736	114.2	8583547.0
2010-01-07 15:00:00	SPY	ETF	114.2	114.23	113.89	114.18	13832900.0
2010-01-07 15:30:00	SPY	ETF	114.18	114.33	114.1	114.2	16476831.0
2010-01-07 16:00:00	SPY	ETF	114.2	114.25	113.48	114.18	9593991.0
2010-01-07 16:30:00	SPY	ETF	114.18	114.2	113.7735	114.16	1600922.0
2010-01-07 17:00:00	SPY	ETF	114.17	114.21	113.7736	114.18	2052272.0
2010-01-07 17:30:00	SPY	ETF	114.18	114.19	114.14	114.15	25572.0
2010-01-07 18:00:00	SPY	ETF	114.16	114.19	113.7736	114.15	517291.0
2010-01-07 18:30:00	SPY	ETF	114.16	114.18	114.14	114.16	16191.0
2010-01-07 19:00:00	SPY	ETF	114.19	114.24	114.18	114.24	23456.0
2010-01-07 19:30:00	SPY	ETF	114.25	114.26	114.19	114.23	32093.0
2010-01-07 04:30:00	QQQ	ETF	46.07	46.07	46.07	46.07	500.0
2010-01-07 05:00:00	QQQ	ETF	46.09	46.09	46.08	46.08	1100.0
2010-01-07 05:30:00	QQQ	ETF	46.03	46.03	46.03	46.03	100.0
2010-01-07 06:00:00	QQQ	ETF	46.05	46.05	46.05	46.05	500.0
2010-01-07 06:30:00	QQQ	ETF	46.11	46.11	46.11	46.11	100.0
2010-01-07 07:00:00	QQQ	ETF	46.12	46.12	46.12	46.12	5000.0
2010-01-07 07:30:00	QQQ	ETF	46.07	46.09	46.05	46.06	545221.0
2010-01-07 08:00:00	QQQ	ETF	46.06	46.14	46.02	46.13	726180.0
2010-01-07 08:30:00	QQQ	ETF	46.14	46.2	46.11	46.16	349363.0
2010-01-07 09:00:00	QQQ	ETF	46.17	46.21	46.15	46.2	272096.0
2010-01-07 09:30:00	QQQ	ETF	46.2	46.27	45.96	45.98	8783698.0
2010-01-07 10:00:00	QQQ	ETF	45.98	46.06	45.92	46.0299	5308408.0
2010-01-07 10:30:00	QQQ	ETF	46.02	46.25	45.9976	46.16	7455820.0
2010-01-07 11:00:00	QQQ	ETF	46.165	46.18	46.06	46.0725	3122826.0
2010-01-07 11:30:00	QQQ	ETF	46.07	46.1	45.99	46.02	4272638.0
2010-01-07 12:00:00	QQQ	ETF	46.02	46.13	46.02	46.06	2753943.0
2010-01-07 12:30:00	QQQ	ETF	46.06	46.11	45.99	46.01	4786346.0
2010-01-07 13:00:00	QQQ	ETF	46.0	46.05	45.95	46.05	2616511.0
2010-01-07 13:30:00	QQQ	ETF	46.04	46.075	45.99	46.01	2326195.0

> showing 50 of 8,147 rows — these rows as CSV

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