PREVIEW / etf_30min / 2015-08-26

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-08-26.parquet
  size:    425 KB
  rows:    14,225

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-08-26 04:00:00	SPY	ETF	189.3	191.64	189.3	191.01	67015.0
2015-08-26 04:30:00	SPY	ETF	191.0	191.25	190.49	190.57	160892.0
2015-08-26 05:00:00	SPY	ETF	190.56	190.9	190.18	190.79	89913.0
2015-08-26 05:30:00	SPY	ETF	190.78	190.82	190.15	190.34	61718.0
2015-08-26 06:00:00	SPY	ETF	190.45	190.7	190.04	190.55	88302.0
2015-08-26 06:30:00	SPY	ETF	190.64	191.43	190.57	191.32	504553.0
2015-08-26 07:00:00	SPY	ETF	191.3	192.25	191.24	191.71	982016.0
2015-08-26 07:30:00	SPY	ETF	191.6	191.66	191.01	191.13	992696.0
2015-08-26 08:00:00	SPY	ETF	191.16	192.06	191.04	191.55	1688866.0
2015-08-26 08:30:00	SPY	ETF	191.58	193.03	191.53	192.3	3660568.0
2015-08-26 09:00:00	SPY	ETF	192.3	192.59	191.56	192.09	3238817.0
2015-08-26 09:30:00	SPY	ETF	192.08	192.49	190.29	190.94	33784412.0
2015-08-26 10:00:00	SPY	ETF	190.92	191.62	189.26	190.38	30276254.0
2015-08-26 10:30:00	SPY	ETF	190.38	191.32	189.73	190.23	23831201.0
2015-08-26 11:00:00	SPY	ETF	190.23	190.55	189.53	189.94	19782148.0
2015-08-26 11:30:00	SPY	ETF	189.93	190.23	188.77	189.53	21672718.0
2015-08-26 12:00:00	SPY	ETF	189.51	189.79	188.9	189.01	17615835.0
2015-08-26 12:30:00	SPY	ETF	189.01	189.78	188.37	189.76	17500325.0
2015-08-26 13:00:00	SPY	ETF	189.76	190.585	189.26	190.585	17130198.0
2015-08-26 13:30:00	SPY	ETF	190.57	191.42	190.2	191.27	17387701.0
2015-08-26 14:00:00	SPY	ETF	191.27	191.36	190.03	190.57	13545843.0
2015-08-26 14:30:00	SPY	ETF	190.57	192.34	190.41	191.999	19826809.0
2015-08-26 15:00:00	SPY	ETF	192.0	193.99	191.61	193.21	30713505.0
2015-08-26 15:30:00	SPY	ETF	193.22	194.79	193.11	194.56	42142672.0
2015-08-26 16:00:00	SPY	ETF	194.55	195.04	189.2725	194.4	11561645.0
2015-08-26 16:30:00	SPY	ETF	194.4	194.9	194.35	194.43	7330910.0
2015-08-26 17:00:00	SPY	ETF	194.41	194.77	191.3319	194.65	1313354.0
2015-08-26 17:30:00	SPY	ETF	194.697	194.88	194.65	194.88	187377.0
2015-08-26 18:00:00	SPY	ETF	194.86	194.93	194.61	194.7	223565.0
2015-08-26 18:30:00	SPY	ETF	194.69	194.8	194.66	194.77	45949.0
2015-08-26 19:00:00	SPY	ETF	194.7	194.76	194.51	194.65	40945.0
2015-08-26 19:30:00	SPY	ETF	194.66	195.0	194.48	194.96	92241.0
2015-08-26 04:00:00	QQQ	ETF	98.82	99.81	98.82	99.81	5348.0
2015-08-26 04:30:00	QQQ	ETF	99.8	99.91	99.49	99.7	3800.0
2015-08-26 05:00:00	QQQ	ETF	99.65	99.75	99.36	99.73	49864.0
2015-08-26 05:30:00	QQQ	ETF	99.69	99.69	99.43	99.55	41738.0
2015-08-26 06:00:00	QQQ	ETF	99.64	99.65	99.36	99.64	21700.0
2015-08-26 06:30:00	QQQ	ETF	99.64	100.1	99.63	100.08	38800.0
2015-08-26 07:00:00	QQQ	ETF	100.05	100.61	100.05	100.29	161966.0
2015-08-26 07:30:00	QQQ	ETF	100.29	100.35	100.14	100.22	92685.0
2015-08-26 08:00:00	QQQ	ETF	99.68	100.5	99.68	100.45	194552.0
2015-08-26 08:30:00	QQQ	ETF	100.47	101.3	100.45	100.96	720227.0
2015-08-26 09:00:00	QQQ	ETF	101.01	101.18	100.64	100.97	369732.0
2015-08-26 09:30:00	QQQ	ETF	100.96	101.41	100.22	100.58	9671327.0
2015-08-26 10:00:00	QQQ	ETF	100.59	101.02	99.66	100.23	6857285.0
2015-08-26 10:30:00	QQQ	ETF	100.24	100.82	99.92	100.255	6910245.0
2015-08-26 11:00:00	QQQ	ETF	100.265	100.33	99.77	99.97	4411976.0
2015-08-26 11:30:00	QQQ	ETF	99.96	100.14	99.15	99.71	5953730.0
2015-08-26 12:00:00	QQQ	ETF	99.7	99.94	99.35	99.41	3658813.0
2015-08-26 12:30:00	QQQ	ETF	99.4	99.79	98.93	99.78	4514191.0

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

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