PREVIEW / etf_30min / 2015-08-24

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-08-24.parquet
  size:    462 KB
  rows:    15,924

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-24 04:00:00	SPY	ETF	194.32	194.34	193.89	194.15	122003.0
2015-08-24 04:30:00	SPY	ETF	194.14	194.56	193.7	194.53	106292.0
2015-08-24 05:00:00	SPY	ETF	194.52	194.67	194.28	194.57	206867.0
2015-08-24 05:30:00	SPY	ETF	194.58	194.97	194.15	194.15	300708.0
2015-08-24 06:00:00	SPY	ETF	194.18	194.39	193.01	193.42	607815.0
2015-08-24 06:30:00	SPY	ETF	193.4	194.22	193.03	194.13	345168.0
2015-08-24 07:00:00	SPY	ETF	194.13	194.13	192.97	192.97	752919.0
2015-08-24 07:30:00	SPY	ETF	193.04	193.09	190.55	190.81	3930327.0
2015-08-24 08:00:00	SPY	ETF	190.82	194.04	189.95	191.55	5233808.0
2015-08-24 08:30:00	SPY	ETF	191.56	193.45	190.2	190.33	4350491.0
2015-08-24 09:00:00	SPY	ETF	190.32	190.66	187.19	187.33	7919573.0
2015-08-24 09:30:00	SPY	ETF	187.49	191.14	182.4	189.81	46897366.0
2015-08-24 10:00:00	SPY	ETF	189.79	193.63	189.09	192.2	45379478.0
2015-08-24 10:30:00	SPY	ETF	192.2	193.27	190.68	192.81	40779543.0
2015-08-24 11:00:00	SPY	ETF	192.81	193.09	191.18	191.49	26883949.0
2015-08-24 11:30:00	SPY	ETF	191.48	194.9	191.19	194.6	30549087.0
2015-08-24 12:00:00	SPY	ETF	194.6	195.65	193.65	195.36	30998328.0
2015-08-24 12:30:00	SPY	ETF	195.36	195.75	194.46	195.07	18929525.0
2015-08-24 13:00:00	SPY	ETF	195.07	195.84	194.06	194.33	14998370.0
2015-08-24 13:30:00	SPY	ETF	194.33	194.33	192.52	192.57	20381027.0
2015-08-24 14:00:00	SPY	ETF	192.57	192.74	191.27	191.96	24648067.0
2015-08-24 14:30:00	SPY	ETF	191.96	192.7	189.18	189.415	29049140.0
2015-08-24 15:00:00	SPY	ETF	189.41	197.4772	188.28	188.7	46705691.0
2015-08-24 15:30:00	SPY	ETF	188.705	193.03	188.21	189.48	67070887.0
2015-08-24 16:00:00	SPY	ETF	189.42	196.53	187.23	187.9	15271537.0
2015-08-24 16:30:00	SPY	ETF	187.94	188.92	187.77	188.25	13533910.0
2015-08-24 17:00:00	SPY	ETF	188.27	188.3	187.65	187.9	5010967.0
2015-08-24 17:30:00	SPY	ETF	187.9	189.55	187.76	188.1	2462538.0
2015-08-24 18:00:00	SPY	ETF	188.06	189.47	188.06	189.2	361694.0
2015-08-24 18:30:00	SPY	ETF	189.25	189.55	188.97	189.25	635149.0
2015-08-24 19:00:00	SPY	ETF	189.24	189.39	188.93	189.06	86920.0
2015-08-24 19:30:00	SPY	ETF	189.05	190.17	188.95	189.84	207028.0
2015-08-24 04:00:00	QQQ	ETF	99.19	101.25	98.93	98.99	24809.0
2015-08-24 04:30:00	QQQ	ETF	98.91	99.01	98.74	99.01	27933.0
2015-08-24 05:00:00	QQQ	ETF	99.01	99.45	99.01	99.39	28250.0
2015-08-24 05:30:00	QQQ	ETF	99.38	99.74	99.38	99.39	25222.0
2015-08-24 06:00:00	QQQ	ETF	99.46	99.5	98.64	98.8	40362.0
2015-08-24 06:30:00	QQQ	ETF	98.8	99.11	98.61	99.11	58302.0
2015-08-24 07:00:00	QQQ	ETF	99.02	99.02	98.32	98.35	327320.0
2015-08-24 07:30:00	QQQ	ETF	98.34	98.35	97.44	97.6	217684.0
2015-08-24 08:00:00	QQQ	ETF	97.52	98.53	97.16	97.35	537347.0
2015-08-24 08:30:00	QQQ	ETF	97.35	97.78	97.18	97.47	269177.0
2015-08-24 09:00:00	QQQ	ETF	97.43	97.57	94.17	94.23	882205.0
2015-08-24 09:30:00	QQQ	ETF	94.22	98.81	84.74	98.02	18619059.0
2015-08-24 10:00:00	QQQ	ETF	98.0	100.35	97.6751	99.88	10531856.0
2015-08-24 10:30:00	QQQ	ETF	99.88	100.64	98.91	100.29	8802777.0
2015-08-24 11:00:00	QQQ	ETF	100.3	100.45	99.4501	99.69	7300395.0
2015-08-24 11:30:00	QQQ	ETF	99.6799	101.94	99.4	101.7705	6946754.0
2015-08-24 12:00:00	QQQ	ETF	101.76	102.53	101.25	102.25	6501300.0
2015-08-24 12:30:00	QQQ	ETF	102.245	102.44	101.47	101.91	5048911.0

> showing 50 of 15,924 rows — these rows as CSV

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