PREVIEW / etf_30min / 2009-12-07

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-12-07.parquet
  size:    231 KB
  rows:    7,706

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-12-07 04:00:00	SPY	ETF	110.64	110.64	110.64	110.64	200.0
2009-12-07 04:30:00	SPY	ETF	110.8	110.9	110.8	110.9	520.0
2009-12-07 05:00:00	SPY	ETF	110.94	110.94	110.88	110.9	5600.0
2009-12-07 05:30:00	SPY	ETF	111.09	111.09	110.9	110.9	15600.0
2009-12-07 06:00:00	SPY	ETF	110.98	111.0	110.98	110.99	10000.0
2009-12-07 06:30:00	SPY	ETF	110.98	110.98	110.85	110.85	20500.0
2009-12-07 07:00:00	SPY	ETF	110.87	110.91	110.8	110.84	478016.0
2009-12-07 07:30:00	SPY	ETF	110.84	111.1	110.84	111.06	288624.0
2009-12-07 08:00:00	SPY	ETF	111.05	111.07	110.83	110.99	355417.0
2009-12-07 08:30:00	SPY	ETF	110.99	111.08	110.75	111.01	921024.0
2009-12-07 09:00:00	SPY	ETF	111.02	111.07	110.89	110.95	505557.0
2009-12-07 09:30:00	SPY	ETF	110.91	111.53	110.88	111.38	18741808.0
2009-12-07 10:00:00	SPY	ETF	111.39	111.45	111.0	111.33	12673966.0
2009-12-07 10:30:00	SPY	ETF	111.33	111.44	111.16	111.23	10121915.0
2009-12-07 11:00:00	SPY	ETF	111.2101	111.22	111.03	111.08	5984065.0
2009-12-07 11:30:00	SPY	ETF	111.07	111.24	111.06	111.2	4778182.0
2009-12-07 12:00:00	SPY	ETF	111.19	111.21	111.04	111.1	3207024.0
2009-12-07 12:30:00	SPY	ETF	111.1	111.44	111.1	111.33	8909545.0
2009-12-07 13:00:00	SPY	ETF	111.32	111.52	111.26	111.4	5776028.0
2009-12-07 13:30:00	SPY	ETF	111.4	111.42	111.17	111.24	5289298.0
2009-12-07 14:00:00	SPY	ETF	111.24	111.28	111.03	111.06	4151788.0
2009-12-07 14:30:00	SPY	ETF	111.06	111.075	110.49	110.68	13205039.0
2009-12-07 15:00:00	SPY	ETF	110.67	110.85	110.55	110.625	8737769.0
2009-12-07 15:30:00	SPY	ETF	110.62	110.96	110.62	110.77	12687672.0
2009-12-07 16:00:00	SPY	ETF	110.78	111.33	110.6099	111.0842	7373804.0
2009-12-07 16:30:00	SPY	ETF	110.96	111.09	110.83	111.07	791453.0
2009-12-07 17:00:00	SPY	ETF	111.05	111.14	111.03	111.12	1769501.0
2009-12-07 17:30:00	SPY	ETF	111.14	111.16	111.11	111.15	18467.0
2009-12-07 18:00:00	SPY	ETF	111.13	111.16	111.09	111.15	57306.0
2009-12-07 18:30:00	SPY	ETF	111.14	111.14	111.06	111.06	32875.0
2009-12-07 19:00:00	SPY	ETF	111.08	111.1	111.06	111.1	17977.0
2009-12-07 19:30:00	SPY	ETF	111.09	111.25	111.09	111.25	99294.0
2009-12-07 04:00:00	QQQ	ETF	43.95	43.95	43.91	43.91	500.0
2009-12-07 05:00:00	QQQ	ETF	44.04	44.08	44.04	44.08	300.0
2009-12-07 06:30:00	QQQ	ETF	44.05	44.06	44.05	44.06	1500.0
2009-12-07 07:00:00	QQQ	ETF	44.0	44.0	44.0	44.0	1000.0
2009-12-07 07:30:00	QQQ	ETF	44.03	44.13	44.03	44.12	10443.0
2009-12-07 08:00:00	QQQ	ETF	44.12	44.12	44.06	44.08	97139.0
2009-12-07 08:30:00	QQQ	ETF	44.08	44.11	43.99	44.09	168764.0
2009-12-07 09:00:00	QQQ	ETF	44.11	44.12	44.05	44.08	108186.0
2009-12-07 09:30:00	QQQ	ETF	44.08	44.29	44.04	44.21	12416691.0
2009-12-07 10:00:00	QQQ	ETF	44.201	44.25	44.1	44.2	5653810.0
2009-12-07 10:30:00	QQQ	ETF	44.2	44.26	44.15	44.16	5616650.0
2009-12-07 11:00:00	QQQ	ETF	44.17	44.18	44.06	44.069	3772286.0
2009-12-07 11:30:00	QQQ	ETF	44.07	44.14	44.06	44.11	3147475.0
2009-12-07 12:00:00	QQQ	ETF	44.12	44.12	44.05	44.06	1659009.0
2009-12-07 12:30:00	QQQ	ETF	44.07	44.18	44.0601	44.12	4491641.0
2009-12-07 13:00:00	QQQ	ETF	44.11	44.19	44.09	44.14	2444792.0
2009-12-07 13:30:00	QQQ	ETF	44.15	44.17	44.0575	44.07	3563166.0
2009-12-07 14:00:00	QQQ	ETF	44.07	44.09	44.0	44.0175	2711973.0

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

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