PREVIEW / etf_30min / 2009-08-26

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-08-26.parquet
  size:    220 KB
  rows:    7,392

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-08-26 04:00:00	SPY	ETF	103.27	103.27	103.15	103.15	2100.0
2009-08-26 04:30:00	SPY	ETF	103.19	103.19	103.19	103.19	500.0
2009-08-26 05:00:00	SPY	ETF	103.16	103.16	103.01	103.01	2100.0
2009-08-26 05:30:00	SPY	ETF	103.11	103.11	103.11	103.11	300.0
2009-08-26 06:00:00	SPY	ETF	103.19	103.19	102.88	102.96	2000.0
2009-08-26 06:30:00	SPY	ETF	102.91	102.92	102.85	102.9	2301.0
2009-08-26 07:00:00	SPY	ETF	102.97	102.97	102.7	102.71	169486.0
2009-08-26 07:30:00	SPY	ETF	102.71	102.92	102.71	102.92	125172.0
2009-08-26 08:00:00	SPY	ETF	102.92	103.45	102.73	103.01	1814623.0
2009-08-26 08:30:00	SPY	ETF	103.0	103.49	102.77	102.96	4356782.0
2009-08-26 09:00:00	SPY	ETF	102.96	102.99	102.82	102.85	1195757.0
2009-08-26 09:30:00	SPY	ETF	102.84	102.98	102.49	102.81	21449250.0
2009-08-26 10:00:00	SPY	ETF	102.82	103.59	102.75	103.37	33156122.0
2009-08-26 10:30:00	SPY	ETF	103.365	103.64	103.2	103.35	17157441.0
2009-08-26 11:00:00	SPY	ETF	103.34	103.38	102.85	102.99	12370441.0
2009-08-26 11:30:00	SPY	ETF	102.99	103.05	102.75	102.97	9087850.0
2009-08-26 12:00:00	SPY	ETF	102.97	103.17	102.89	103.11	5878530.0
2009-08-26 12:30:00	SPY	ETF	103.11	103.5052	102.9	102.98	8374132.0
2009-08-26 13:00:00	SPY	ETF	102.99	103.01	102.7	102.88	7137165.0
2009-08-26 13:30:00	SPY	ETF	102.88	103.25	102.86	103.25	8690588.0
2009-08-26 14:00:00	SPY	ETF	103.25	103.31	103.06	103.0817	5785569.0
2009-08-26 14:30:00	SPY	ETF	103.09	103.32	102.9	102.93	10422106.0
2009-08-26 15:00:00	SPY	ETF	102.94	103.15	102.88	103.01	8823752.0
2009-08-26 15:30:00	SPY	ETF	103.01	103.27	102.86	103.18	19705578.0
2009-08-26 16:00:00	SPY	ETF	103.19	103.4	102.94	103.17	4007893.0
2009-08-26 16:30:00	SPY	ETF	103.17	103.17	103.03	103.07	2517247.0
2009-08-26 17:00:00	SPY	ETF	103.08	103.15	103.08	103.13	5202150.0
2009-08-26 17:30:00	SPY	ETF	103.16	103.18	103.11	103.13	263401.0
2009-08-26 18:00:00	SPY	ETF	103.13	103.18	103.07	103.07	221028.0
2009-08-26 18:30:00	SPY	ETF	103.11	103.14	103.11	103.12	7200.0
2009-08-26 19:00:00	SPY	ETF	103.13	103.16	103.13	103.13	11093.0
2009-08-26 19:30:00	SPY	ETF	103.14	103.14	103.05	103.05	19144.0
2009-08-26 06:00:00	QQQ	ETF	40.37	40.37	40.37	40.37	200.0
2009-08-26 06:30:00	QQQ	ETF	40.26	40.3	40.26	40.3	1048.0
2009-08-26 07:00:00	QQQ	ETF	40.34	40.34	40.22	40.22	5736.0
2009-08-26 07:30:00	QQQ	ETF	40.23	40.29	40.22	40.29	17100.0
2009-08-26 08:00:00	QQQ	ETF	40.28	40.41	40.27	40.3	1038925.0
2009-08-26 08:30:00	QQQ	ETF	40.36	40.46	40.25	40.32	1113923.0
2009-08-26 09:00:00	QQQ	ETF	40.3	40.34	40.28	40.3	302320.0
2009-08-26 09:30:00	QQQ	ETF	40.29	40.38	40.2	40.36	11207793.0
2009-08-26 10:00:00	QQQ	ETF	40.37	40.601	40.33	40.4699	14519450.0
2009-08-26 10:30:00	QQQ	ETF	40.4601	40.56	40.38	40.41	6416860.0
2009-08-26 11:00:00	QQQ	ETF	40.41	40.43	40.16	40.2	6720275.0
2009-08-26 11:30:00	QQQ	ETF	40.2099	40.24	40.09	40.15	4148689.0
2009-08-26 12:00:00	QQQ	ETF	40.15	40.26	40.1	40.22	4539506.0
2009-08-26 12:30:00	QQQ	ETF	40.21	40.27	40.14	40.1696	4052971.0
2009-08-26 13:00:00	QQQ	ETF	40.17	40.19	40.08	40.1599	5502558.0
2009-08-26 13:30:00	QQQ	ETF	40.16	40.36	40.145	40.36	5373885.0
2009-08-26 14:00:00	QQQ	ETF	40.36	40.37	40.15	40.29	3091536.0
2009-08-26 14:30:00	QQQ	ETF	40.2901	40.4	40.15	40.26	6116055.0

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

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