PREVIEW / etf_30min / 2015-08-25

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-08-25.parquet
  size:    442 KB
  rows:    15,021

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-25 04:00:00	SPY	ETF	193.34	194.27	193.15	193.9	118838.0
2015-08-25 04:30:00	SPY	ETF	194.1	194.45	193.19	193.59	89362.0
2015-08-25 05:00:00	SPY	ETF	193.45	193.9	193.1	193.76	75097.0
2015-08-25 05:30:00	SPY	ETF	193.72	194.4	193.58	193.93	158307.0
2015-08-25 06:00:00	SPY	ETF	194.07	195.62	192.94	194.49	1101427.0
2015-08-25 06:30:00	SPY	ETF	194.55	195.39	193.77	194.13	780214.0
2015-08-25 07:00:00	SPY	ETF	194.06	195.45	193.74	195.0	996730.0
2015-08-25 07:30:00	SPY	ETF	195.0	195.5	194.52	195.11	1541271.0
2015-08-25 08:00:00	SPY	ETF	195.11	195.48	193.9	194.33	3597548.0
2015-08-25 08:30:00	SPY	ETF	194.3	194.65	193.86	193.95	2025847.0
2015-08-25 09:00:00	SPY	ETF	193.9	195.5	193.79	195.45	4279465.0
2015-08-25 09:30:00	SPY	ETF	195.43	195.45	193.41	193.85	42150016.0
2015-08-25 10:00:00	SPY	ETF	193.85	194.559	193.09	193.47	35748175.0
2015-08-25 10:30:00	SPY	ETF	193.47	193.81	192.97	193.58	17731991.0
2015-08-25 11:00:00	SPY	ETF	193.57	195.24	193.56	194.54	18609980.0
2015-08-25 11:30:00	SPY	ETF	194.54	194.6	193.9	193.96	21541442.0
2015-08-25 12:00:00	SPY	ETF	193.96	194.4	193.77	194.1	12299224.0
2015-08-25 12:30:00	SPY	ETF	194.09	194.35	193.53	193.62	12062397.0
2015-08-25 13:00:00	SPY	ETF	193.62	193.96	191.97	192.06	21830480.0
2015-08-25 13:30:00	SPY	ETF	192.07	192.91	191.78	192.545	20234512.0
2015-08-25 14:00:00	SPY	ETF	192.5499	195.45	191.9	192.46	16182131.0
2015-08-25 14:30:00	SPY	ETF	192.46	193.41	192.15	193.01	13002352.0
2015-08-25 15:00:00	SPY	ETF	193.01	193.23	190.67	190.8	25056697.0
2015-08-25 15:30:00	SPY	ETF	190.8	191.01	187.06	187.24	72314721.0
2015-08-25 16:00:00	SPY	ETF	187.23	194.48	186.82	187.96	14977928.0
2015-08-25 16:30:00	SPY	ETF	187.97	187.98	187.27	187.72	7817693.0
2015-08-25 17:00:00	SPY	ETF	187.72	192.2936	187.27	187.91	440465.0
2015-08-25 17:30:00	SPY	ETF	187.94	188.52	187.75	188.46	328558.0
2015-08-25 18:00:00	SPY	ETF	188.45	188.64	187.45	187.45	475411.0
2015-08-25 18:30:00	SPY	ETF	187.45	187.71	186.44	187.4	578786.0
2015-08-25 19:00:00	SPY	ETF	187.4	187.63	186.47	187.09	431462.0
2015-08-25 19:30:00	SPY	ETF	187.1	187.15	185.79	185.81	420396.0
2015-08-25 04:00:00	QQQ	ETF	100.39	101.32	100.39	101.32	2181.0
2015-08-25 04:30:00	QQQ	ETF	101.22	101.49	100.87	100.92	3931.0
2015-08-25 05:00:00	QQQ	ETF	100.88	100.94	100.88	100.94	8101.0
2015-08-25 05:30:00	QQQ	ETF	101.22	101.39	101.2	101.35	3100.0
2015-08-25 06:00:00	QQQ	ETF	101.37	102.3	101.36	101.87	11920.0
2015-08-25 06:30:00	QQQ	ETF	101.9	102.49	101.77	101.77	66335.0
2015-08-25 07:00:00	QQQ	ETF	101.76	102.4	101.61	102.22	80031.0
2015-08-25 07:30:00	QQQ	ETF	102.2	102.25	101.9	102.17	106618.0
2015-08-25 08:00:00	QQQ	ETF	102.16	102.29	101.39	101.61	309458.0
2015-08-25 08:30:00	QQQ	ETF	101.63	101.8	101.33	101.35	512865.0
2015-08-25 09:00:00	QQQ	ETF	101.32	104.97	101.28	102.15	679612.0
2015-08-25 09:30:00	QQQ	ETF	102.07	102.25	101.0605	101.57	10048681.0
2015-08-25 10:00:00	QQQ	ETF	101.57	102.2	101.29	101.64	5759826.0
2015-08-25 10:30:00	QQQ	ETF	101.63	101.84	101.35	101.79	3209976.0
2015-08-25 11:00:00	QQQ	ETF	101.81	102.74	101.8	102.409	3041743.0
2015-08-25 11:30:00	QQQ	ETF	102.41	102.54	102.12	102.1999	1861738.0
2015-08-25 12:00:00	QQQ	ETF	102.19	102.39	102.01	102.195	1783235.0
2015-08-25 12:30:00	QQQ	ETF	102.195	102.36	101.94	101.97	1578262.0

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

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