PREVIEW / etf_30min / 2017-05-26

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-05-26.parquet
  size:    412 KB
  rows:    14,353

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
2017-05-26 04:00:00	SPY	ETF	241.79	241.8	241.61	241.61	2200.0
2017-05-26 04:30:00	SPY	ETF	241.59	241.59	241.44	241.49	3250.0
2017-05-26 05:00:00	SPY	ETF	241.47	241.54	241.42	241.52	2700.0
2017-05-26 05:30:00	SPY	ETF	241.47	241.53	241.37	241.37	17525.0
2017-05-26 06:00:00	SPY	ETF	241.4	241.5	241.4	241.5	14910.0
2017-05-26 06:30:00	SPY	ETF	241.48	241.48	241.42	241.42	700.0
2017-05-26 07:00:00	SPY	ETF	241.5	241.5	241.2	241.2	75920.0
2017-05-26 07:30:00	SPY	ETF	241.26	241.28	241.18	241.21	276227.0
2017-05-26 08:00:00	SPY	ETF	241.22	241.41	241.17	241.31	75706.0
2017-05-26 08:30:00	SPY	ETF	241.33	241.51	241.26	241.46	162981.0
2017-05-26 09:00:00	SPY	ETF	241.49	241.59	241.48	241.54	142999.0
2017-05-26 09:30:00	SPY	ETF	241.54	241.79	241.45	241.73	4301212.0
2017-05-26 10:00:00	SPY	ETF	241.73	241.84	241.6004	241.66	2473604.0
2017-05-26 10:30:00	SPY	ETF	241.665	241.9	241.6	241.6	2507079.0
2017-05-26 11:00:00	SPY	ETF	241.6073	241.79	241.6	241.765	1906052.0
2017-05-26 11:30:00	SPY	ETF	241.76	241.8	241.52	241.53	2353991.0
2017-05-26 12:00:00	SPY	ETF	241.53	241.78	241.52	241.75	1217374.0
2017-05-26 12:30:00	SPY	ETF	241.76	241.82	241.69	241.76	1366579.0
2017-05-26 13:00:00	SPY	ETF	241.76	241.84	241.68	241.73	1515478.0
2017-05-26 13:30:00	SPY	ETF	241.72	241.7558	241.64	241.68	1435822.0
2017-05-26 14:00:00	SPY	ETF	241.68	241.8	241.63	241.785	1954101.0
2017-05-26 14:30:00	SPY	ETF	241.79	241.81	241.72	241.7375	1238771.0
2017-05-26 15:00:00	SPY	ETF	241.73	241.81	241.66	241.7	1927853.0
2017-05-26 15:30:00	SPY	ETF	241.69	241.84	241.63	241.74	7255240.0
2017-05-26 16:00:00	SPY	ETF	241.75	241.7971	241.67	241.76	11151381.0
2017-05-26 16:30:00	SPY	ETF	241.76	241.8	241.7	241.8	946570.0
2017-05-26 17:00:00	SPY	ETF	241.78	241.8	241.72	241.78	38241.0
2017-05-26 17:30:00	SPY	ETF	241.78	241.79	241.77	241.77	25301.0
2017-05-26 18:00:00	SPY	ETF	241.78	241.78	241.77	241.77	750.0
2017-05-26 18:30:00	SPY	ETF	241.78	241.79	241.76	241.77	26101.0
2017-05-26 19:00:00	SPY	ETF	241.77	241.78	241.77	241.77	3185.0
2017-05-26 19:30:00	SPY	ETF	241.77	241.8	241.77	241.8	50916.0
2017-05-26 04:00:00	QQQ	ETF	141.03	141.03	141.03	141.03	100.0
2017-05-26 04:30:00	QQQ	ETF	141.05	141.05	140.97	140.97	1400.0
2017-05-26 05:00:00	QQQ	ETF	140.96	141.0	140.96	141.0	600.0
2017-05-26 05:30:00	QQQ	ETF	140.95	140.95	140.89	140.89	1100.0
2017-05-26 06:00:00	QQQ	ETF	140.93	140.98	140.93	140.98	1350.0
2017-05-26 06:30:00	QQQ	ETF	140.96	140.96	140.92	140.92	2400.0
2017-05-26 07:00:00	QQQ	ETF	140.91	140.91	140.79	140.8	11434.0
2017-05-26 07:30:00	QQQ	ETF	140.8	140.83	140.78	140.79	5570.0
2017-05-26 08:00:00	QQQ	ETF	140.79	140.88	140.78	140.85	25996.0
2017-05-26 08:30:00	QQQ	ETF	140.89	140.95	140.89	140.93	17965.0
2017-05-26 09:00:00	QQQ	ETF	140.96	141.01	140.94	141.0	14996.0
2017-05-26 09:30:00	QQQ	ETF	141.0	141.1251	140.81	141.11	1436732.0
2017-05-26 10:00:00	QQQ	ETF	141.1073	141.23	141.071	141.11	821149.0
2017-05-26 10:30:00	QQQ	ETF	141.12	141.28	141.1	141.1	559072.0
2017-05-26 11:00:00	QQQ	ETF	141.1	141.155	141.03	141.105	666923.0
2017-05-26 11:30:00	QQQ	ETF	141.11	141.17	140.97	140.97	697211.0
2017-05-26 12:00:00	QQQ	ETF	140.97	141.1254	140.9634	141.11	477978.0
2017-05-26 12:30:00	QQQ	ETF	141.11	141.13	141.059	141.07	355655.0

> showing 50 of 14,353 rows — these rows as CSV

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