PREVIEW / etf_30min / 2015-09-17

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-09-17.parquet
  size:    373 KB
  rows:    12,532

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
2015-09-17 04:00:00	SPY	ETF	200.15	200.15	199.85	199.98	24007.0
2015-09-17 04:30:00	SPY	ETF	200.03	200.32	200.0	200.1	8011.0
2015-09-17 05:00:00	SPY	ETF	200.12	200.27	199.92	199.99	20663.0
2015-09-17 05:30:00	SPY	ETF	200.04	200.05	199.89	199.99	15213.0
2015-09-17 06:00:00	SPY	ETF	200.01	200.12	200.0	200.05	8050.0
2015-09-17 06:30:00	SPY	ETF	200.11	200.38	200.11	200.24	28661.0
2015-09-17 07:00:00	SPY	ETF	200.22	200.3	200.17	200.21	100610.0
2015-09-17 07:30:00	SPY	ETF	200.22	200.22	199.91	199.96	105793.0
2015-09-17 08:00:00	SPY	ETF	199.94	200.27	199.91	199.97	299919.0
2015-09-17 08:30:00	SPY	ETF	199.97	200.06	199.8	200.0	280180.0
2015-09-17 09:00:00	SPY	ETF	200.0	200.18	199.34	200.02	564140.0
2015-09-17 09:30:00	SPY	ETF	200.02	200.28	199.81	200.135	11624453.0
2015-09-17 10:00:00	SPY	ETF	200.13	200.41	200.0	200.18	9070973.0
2015-09-17 10:30:00	SPY	ETF	200.17	200.37	199.98	200.3062	9079462.0
2015-09-17 11:00:00	SPY	ETF	200.29	200.535	200.24	200.39	7540817.0
2015-09-17 11:30:00	SPY	ETF	200.39	200.45	200.24	200.303	5394588.0
2015-09-17 12:00:00	SPY	ETF	200.31	200.61	200.2	200.55	5780115.0
2015-09-17 12:30:00	SPY	ETF	200.55	200.76	200.32	200.645	13789601.0
2015-09-17 13:00:00	SPY	ETF	200.645	201.11	200.5	200.89	8343651.0
2015-09-17 13:30:00	SPY	ETF	200.885	201.05	200.7	200.7892	7809680.0
2015-09-17 14:00:00	SPY	ETF	200.79	201.59	199.29	200.57	51296937.0
2015-09-17 14:30:00	SPY	ETF	200.58	202.89	200.56	202.2	36334943.0
2015-09-17 15:00:00	SPY	ETF	202.19	202.44	199.28	200.34	32545416.0
2015-09-17 15:30:00	SPY	ETF	200.33	200.84	199.33	199.76	42464695.0
2015-09-17 16:00:00	SPY	ETF	199.7	202.8507	198.99	199.26	15142285.0
2015-09-17 16:30:00	SPY	ETF	199.25	201.0	199.25	199.4	12327778.0
2015-09-17 17:00:00	SPY	ETF	199.43	201.0	199.31	199.35	1905152.0
2015-09-17 17:30:00	SPY	ETF	199.35	199.46	199.33	199.43	65126.0
2015-09-17 18:00:00	SPY	ETF	199.43	199.45	199.24	199.41	133957.0
2015-09-17 18:30:00	SPY	ETF	199.41	199.67	199.4	199.64	116299.0
2015-09-17 19:00:00	SPY	ETF	199.61	199.61	199.39	199.5	49355.0
2015-09-17 19:30:00	SPY	ETF	199.49	199.52	199.37	199.4	58874.0
2015-09-17 06:00:00	QQQ	ETF	107.05	107.07	107.05	107.07	400.0
2015-09-17 07:00:00	QQQ	ETF	107.16	107.16	107.13	107.13	800.0
2015-09-17 07:30:00	QQQ	ETF	107.16	107.16	106.99	106.99	9500.0
2015-09-17 08:00:00	QQQ	ETF	107.13	107.17	106.99	107.06	53983.0
2015-09-17 08:30:00	QQQ	ETF	107.05	107.08	106.92	107.03	46969.0
2015-09-17 09:00:00	QQQ	ETF	107.03	107.06	106.96	106.99	110553.0
2015-09-17 09:30:00	QQQ	ETF	106.98	107.12	106.84	107.01	2641692.0
2015-09-17 10:00:00	QQQ	ETF	106.99	107.235	106.934	107.12	1511441.0
2015-09-17 10:30:00	QQQ	ETF	107.11	107.225	106.99	107.17	757499.0
2015-09-17 11:00:00	QQQ	ETF	107.17	107.29	107.107	107.19	1487911.0
2015-09-17 11:30:00	QQQ	ETF	107.19	107.22	107.06	107.14	992582.0
2015-09-17 12:00:00	QQQ	ETF	107.14	107.32	107.07	107.295	724586.0
2015-09-17 12:30:00	QQQ	ETF	107.295	107.39	107.16	107.31	1449685.0
2015-09-17 13:00:00	QQQ	ETF	107.31	107.55	107.22	107.42	1567466.0
2015-09-17 13:30:00	QQQ	ETF	107.43	107.5299	107.28	107.33	1481124.0
2015-09-17 14:00:00	QQQ	ETF	107.37	107.89	106.64	107.42	8080467.0
2015-09-17 14:30:00	QQQ	ETF	107.43	108.725	107.41	108.4	6339185.0
2015-09-17 15:00:00	QQQ	ETF	108.41	108.59	106.89	107.51	6644320.0

> showing 50 of 12,532 rows — these rows as CSV

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