PREVIEW / etf_30min / 2015-07-13

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-07-13.parquet
  size:    385 KB
  rows:    13,168

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-07-13 04:00:00	SPY	ETF	208.04	208.33	208.04	208.17	131730.0
2015-07-13 04:30:00	SPY	ETF	208.17	208.39	208.05	208.39	35937.0
2015-07-13 05:00:00	SPY	ETF	208.36	208.97	208.36	208.85	53716.0
2015-07-13 05:30:00	SPY	ETF	208.82	209.25	208.74	208.98	70296.0
2015-07-13 06:00:00	SPY	ETF	209.0	209.0	208.79	208.85	20056.0
2015-07-13 06:30:00	SPY	ETF	208.84	208.9	208.75	208.8	64790.0
2015-07-13 07:00:00	SPY	ETF	208.8	208.95	208.69	208.85	166092.0
2015-07-13 07:30:00	SPY	ETF	208.81	209.0	208.75	208.84	476992.0
2015-07-13 08:00:00	SPY	ETF	208.84	209.0	208.58	208.67	712348.0
2015-07-13 08:30:00	SPY	ETF	208.67	208.85	208.64	208.75	469400.0
2015-07-13 09:00:00	SPY	ETF	208.76	209.01	208.75	208.99	728772.0
2015-07-13 09:30:00	SPY	ETF	208.99	209.56	208.94	209.32	15920403.0
2015-07-13 10:00:00	SPY	ETF	209.32	209.6399	209.26	209.34	9485694.0
2015-07-13 10:30:00	SPY	ETF	209.34	209.455	209.23	209.385	6300397.0
2015-07-13 11:00:00	SPY	ETF	209.38	209.49	209.17	209.38	5242080.0
2015-07-13 11:30:00	SPY	ETF	209.38	209.58	209.32	209.43	4691625.0
2015-07-13 12:00:00	SPY	ETF	209.43	209.46	209.23	209.35	6026887.0
2015-07-13 12:30:00	SPY	ETF	209.36	209.4	209.13	209.18	3171440.0
2015-07-13 13:00:00	SPY	ETF	209.17	209.38	209.17	209.33	3668579.0
2015-07-13 13:30:00	SPY	ETF	209.33	209.3999	209.19	209.275	3239371.0
2015-07-13 14:00:00	SPY	ETF	209.28	209.52	209.275	209.42	4998322.0
2015-07-13 14:30:00	SPY	ETF	209.42	209.72	209.37	209.65	6359048.0
2015-07-13 15:00:00	SPY	ETF	209.66	209.81	209.6	209.8	7492486.0
2015-07-13 15:30:00	SPY	ETF	209.795	209.9	209.67	209.76	17845087.0
2015-07-13 16:00:00	SPY	ETF	209.79	210.0	209.4799	209.95	7333710.0
2015-07-13 16:30:00	SPY	ETF	209.94	209.95	209.88	209.88	250827.0
2015-07-13 17:00:00	SPY	ETF	209.9	209.97	207.4944	209.95	299869.0
2015-07-13 17:30:00	SPY	ETF	209.95	209.97	209.89	209.89	39442.0
2015-07-13 18:00:00	SPY	ETF	209.91	209.92	209.83	209.88	193647.0
2015-07-13 18:30:00	SPY	ETF	209.87	209.89	209.84	209.86	41050.0
2015-07-13 19:00:00	SPY	ETF	209.84	209.86	209.8	209.8	17990.0
2015-07-13 19:30:00	SPY	ETF	209.8	209.91	209.8	209.91	56490.0
2015-07-13 04:00:00	QQQ	ETF	108.1	108.28	108.1	108.28	7000.0
2015-07-13 04:30:00	QQQ	ETF	108.24	108.24	108.24	108.24	100.0
2015-07-13 05:00:00	QQQ	ETF	108.5	108.5	108.47	108.47	800.0
2015-07-13 05:30:00	QQQ	ETF	108.5	108.75	108.37	108.74	13900.0
2015-07-13 06:00:00	QQQ	ETF	108.54	108.54	108.53	108.53	21000.0
2015-07-13 06:30:00	QQQ	ETF	108.54	108.55	108.5	108.51	36010.0
2015-07-13 07:00:00	QQQ	ETF	108.48	108.55	108.43	108.49	82596.0
2015-07-13 07:30:00	QQQ	ETF	108.5	108.53	108.44	108.51	88820.0
2015-07-13 08:00:00	QQQ	ETF	108.48	108.52	108.37	108.45	77177.0
2015-07-13 08:30:00	QQQ	ETF	108.45	108.54	108.44	108.5	59257.0
2015-07-13 09:00:00	QQQ	ETF	108.48	108.59	108.48	108.58	367304.0
2015-07-13 09:30:00	QQQ	ETF	108.58	109.19	108.57	109.05	4078240.0
2015-07-13 10:00:00	QQQ	ETF	109.05	109.29	109.04	109.105	2337751.0
2015-07-13 10:30:00	QQQ	ETF	109.1149	109.23	109.06	109.17	1284085.0
2015-07-13 11:00:00	QQQ	ETF	109.18	109.26	109.05	109.18	1583452.0
2015-07-13 11:30:00	QQQ	ETF	109.19	109.34	109.165	109.3168	1519288.0
2015-07-13 12:00:00	QQQ	ETF	109.32	109.36	109.23	109.34	926607.0
2015-07-13 12:30:00	QQQ	ETF	109.335	109.36	109.17	109.23	884931.0

> showing 50 of 13,168 rows — these rows as CSV

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