PREVIEW / etf_30min / 2015-08-12

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-08-12.parquet
  size:    403 KB
  rows:    13,415

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-12 04:00:00	SPY	ETF	206.88	206.95	206.45	206.79	50140.0
2015-08-12 04:30:00	SPY	ETF	206.73	206.73	206.11	206.2	93416.0
2015-08-12 05:00:00	SPY	ETF	206.18	206.54	206.12	206.45	82351.0
2015-08-12 05:30:00	SPY	ETF	206.45	206.45	206.2	206.21	70240.0
2015-08-12 06:00:00	SPY	ETF	206.23	206.86	206.23	206.79	71349.0
2015-08-12 06:30:00	SPY	ETF	206.77	207.14	206.73	206.91	163670.0
2015-08-12 07:00:00	SPY	ETF	206.92	207.07	206.76	206.83	279145.0
2015-08-12 07:30:00	SPY	ETF	206.83	207.2	206.8	207.11	169643.0
2015-08-12 08:00:00	SPY	ETF	207.11	207.4	205.9	207.19	881181.0
2015-08-12 08:30:00	SPY	ETF	207.19	207.39	206.26	207.22	442524.0
2015-08-12 09:00:00	SPY	ETF	207.23	207.45	206.85	207.09	1052416.0
2015-08-12 09:30:00	SPY	ETF	207.11	207.21	206.36	206.59	20273421.0
2015-08-12 10:00:00	SPY	ETF	206.6	206.64	205.36	205.845	22820594.0
2015-08-12 10:30:00	SPY	ETF	205.845	206.03	205.56	205.74	16742229.0
2015-08-12 11:00:00	SPY	ETF	205.74	206.36	205.7375	206.34	13946193.0
2015-08-12 11:30:00	SPY	ETF	206.34	206.34	205.8	205.87	7813821.0
2015-08-12 12:00:00	SPY	ETF	205.87	206.57	205.675	206.565	7374889.0
2015-08-12 12:30:00	SPY	ETF	206.57	207.12	206.49	206.873	7885940.0
2015-08-12 13:00:00	SPY	ETF	206.88	207.61	206.875	207.34	8906611.0
2015-08-12 13:30:00	SPY	ETF	207.335	208.105	207.22	207.94	6886571.0
2015-08-12 14:00:00	SPY	ETF	207.94	208.01	207.45	207.54	8174934.0
2015-08-12 14:30:00	SPY	ETF	207.53	208.54	207.47	208.51	10401124.0
2015-08-12 15:00:00	SPY	ETF	208.5	209.01	208.33	208.95	11023397.0
2015-08-12 15:30:00	SPY	ETF	208.95	209.14	208.65	208.89	18481730.0
2015-08-12 16:00:00	SPY	ETF	208.88	209.12	208.75	209.07	3926694.0
2015-08-12 16:30:00	SPY	ETF	209.07	209.09	208.98	209.04	1724690.0
2015-08-12 17:00:00	SPY	ETF	209.02	209.02	208.92	208.97	125398.0
2015-08-12 17:30:00	SPY	ETF	208.97	208.97	208.91	208.93	33949.0
2015-08-12 18:00:00	SPY	ETF	208.93	209.0	208.88	208.92	46629.0
2015-08-12 18:30:00	SPY	ETF	208.91	208.91	208.82	208.88	87455.0
2015-08-12 19:00:00	SPY	ETF	208.88	208.89	208.84	208.86	27127.0
2015-08-12 19:30:00	SPY	ETF	208.87	208.9	208.82	208.9	28600.0
2015-08-12 04:00:00	QQQ	ETF	109.29	109.29	109.05	109.06	14100.0
2015-08-12 04:30:00	QQQ	ETF	109.04	109.04	109.0	109.0	210.0
2015-08-12 05:00:00	QQQ	ETF	109.0	109.0	109.0	109.0	250.0
2015-08-12 05:30:00	QQQ	ETF	108.97	108.97	108.85	108.85	14100.0
2015-08-12 06:00:00	QQQ	ETF	108.86	109.15	108.82	109.15	14444.0
2015-08-12 06:30:00	QQQ	ETF	109.1	109.32	109.1	109.19	23900.0
2015-08-12 07:00:00	QQQ	ETF	109.21	109.22	109.11	109.12	187200.0
2015-08-12 07:30:00	QQQ	ETF	109.11	109.32	109.11	109.31	143667.0
2015-08-12 08:00:00	QQQ	ETF	109.3	109.41	109.17	109.33	95772.0
2015-08-12 08:30:00	QQQ	ETF	109.31	109.43	109.25	109.4	145859.0
2015-08-12 09:00:00	QQQ	ETF	109.42	109.44	109.29	109.39	72847.0
2015-08-12 09:30:00	QQQ	ETF	109.38	109.39	108.6451	108.86	6476221.0
2015-08-12 10:00:00	QQQ	ETF	108.87	108.97	108.25	108.58	4619267.0
2015-08-12 10:30:00	QQQ	ETF	108.57	108.639	108.22	108.395	2620769.0
2015-08-12 11:00:00	QQQ	ETF	108.4	109.099	108.3875	109.075	2723215.0
2015-08-12 11:30:00	QQQ	ETF	109.089	109.0899	108.5	108.55	2062138.0
2015-08-12 12:00:00	QQQ	ETF	108.55	109.0	108.444	109.0	1277328.0
2015-08-12 12:30:00	QQQ	ETF	109.01	109.44	108.94	109.34	2105505.0

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

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