PREVIEW / etf_30min / 2015-05-07

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-05-07.parquet
  size:    378 KB
  rows:    12,731

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-05-07 04:00:00	SPY	ETF	207.6	207.86	207.29	207.29	12255.0
2015-05-07 04:30:00	SPY	ETF	207.25	207.28	206.96	207.25	33419.0
2015-05-07 05:00:00	SPY	ETF	207.21	207.21	206.31	206.8	158388.0
2015-05-07 05:30:00	SPY	ETF	206.85	206.9	206.54	206.84	85035.0
2015-05-07 06:00:00	SPY	ETF	206.94	207.05	206.72	206.82	57077.0
2015-05-07 06:30:00	SPY	ETF	206.83	206.92	206.48	206.89	252204.0
2015-05-07 07:00:00	SPY	ETF	206.91	207.19	206.91	207.15	573802.0
2015-05-07 07:30:00	SPY	ETF	207.18	207.72	207.15	207.72	505579.0
2015-05-07 08:00:00	SPY	ETF	207.7	208.21	206.95	207.94	1165870.0
2015-05-07 08:30:00	SPY	ETF	207.95	207.98	207.43	207.56	967981.0
2015-05-07 09:00:00	SPY	ETF	207.55	207.98	207.54	207.92	1060901.0
2015-05-07 09:30:00	SPY	ETF	207.92	208.39	207.57	207.66	12977216.0
2015-05-07 10:00:00	SPY	ETF	207.65	208.22	207.52	207.9	8823926.0
2015-05-07 10:30:00	SPY	ETF	207.84	208.6499	207.59	208.45	8125159.0
2015-05-07 11:00:00	SPY	ETF	208.46	209.02	208.3101	208.93	5007440.0
2015-05-07 11:30:00	SPY	ETF	208.93	208.99	208.66	208.71	3823132.0
2015-05-07 12:00:00	SPY	ETF	208.71	209.25	208.6805	209.16	3679954.0
2015-05-07 12:30:00	SPY	ETF	209.17	209.38	209.13	209.21	3486875.0
2015-05-07 13:00:00	SPY	ETF	209.21	209.36	208.84	208.95	3704788.0
2015-05-07 13:30:00	SPY	ETF	208.95	209.17	208.91	208.95	2613389.0
2015-05-07 14:00:00	SPY	ETF	208.95	209.21	208.95	209.17	2381328.0
2015-05-07 14:30:00	SPY	ETF	209.18	209.25	208.95	209.099	3710737.0
2015-05-07 15:00:00	SPY	ETF	209.09	209.21	208.69	208.83	5661548.0
2015-05-07 15:30:00	SPY	ETF	208.82	209.075	208.62	208.87	11035798.0
2015-05-07 16:00:00	SPY	ETF	208.88	209.02	208.81	208.93	6556094.0
2015-05-07 16:30:00	SPY	ETF	208.93	208.98	208.87	208.93	968659.0
2015-05-07 17:00:00	SPY	ETF	208.91	209.02	208.9	209.02	76036.0
2015-05-07 17:30:00	SPY	ETF	209.03	209.08	208.0407	209.08	16062.0
2015-05-07 18:00:00	SPY	ETF	209.07	209.09	208.95	208.97	180324.0
2015-05-07 18:30:00	SPY	ETF	209.0	209.0	208.96	208.99	4130.0
2015-05-07 19:00:00	SPY	ETF	209.0	209.0	208.95	208.97	14130.0
2015-05-07 19:30:00	SPY	ETF	208.97	209.05	208.961	209.05	15750.0
2015-05-07 04:00:00	QQQ	ETF	106.6	106.6	106.6	106.6	100.0
2015-05-07 04:30:00	QQQ	ETF	106.23	106.23	106.23	106.23	800.0
2015-05-07 05:00:00	QQQ	ETF	105.9	106.11	105.8	106.11	10200.0
2015-05-07 05:30:00	QQQ	ETF	105.96	105.96	105.93	105.93	6475.0
2015-05-07 06:00:00	QQQ	ETF	106.13	106.14	106.01	106.01	9500.0
2015-05-07 06:30:00	QQQ	ETF	105.98	106.14	105.9	106.14	27700.0
2015-05-07 07:00:00	QQQ	ETF	106.14	106.33	106.14	106.26	33293.0
2015-05-07 07:30:00	QQQ	ETF	106.33	106.62	106.33	106.62	83792.0
2015-05-07 08:00:00	QQQ	ETF	106.62	106.86	105.93	106.67	270528.0
2015-05-07 08:30:00	QQQ	ETF	106.67	106.67	106.41	106.48	98400.0
2015-05-07 09:00:00	QQQ	ETF	106.54	106.73	106.49	106.67	243965.0
2015-05-07 09:30:00	QQQ	ETF	106.68	107.36	106.6	106.86	5888965.0
2015-05-07 10:00:00	QQQ	ETF	106.85	107.18	106.71	106.92	2497433.0
2015-05-07 10:30:00	QQQ	ETF	106.92	107.35	106.74	107.17	2651522.0
2015-05-07 11:00:00	QQQ	ETF	107.18	107.42	107.0605	107.38	1594354.0
2015-05-07 11:30:00	QQQ	ETF	107.38	107.42	107.21	107.25	1617133.0
2015-05-07 12:00:00	QQQ	ETF	107.24	107.49	107.21	107.48	1220245.0
2015-05-07 12:30:00	QQQ	ETF	107.48	107.63	107.48	107.55	875112.0

> showing 50 of 12,731 rows — these rows as CSV

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