PREVIEW / etf_30min / 2015-05-28

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-05-28.parquet
  size:    368 KB
  rows:    12,449

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-28 04:00:00	SPY	ETF	212.28	212.35	212.25	212.35	1823.0
2015-05-28 04:30:00	SPY	ETF	212.44	212.45	212.44	212.45	2400.0
2015-05-28 05:00:00	SPY	ETF	212.42	212.42	212.25	212.25	60802.0
2015-05-28 05:30:00	SPY	ETF	212.36	212.43	212.32	212.43	4011.0
2015-05-28 06:00:00	SPY	ETF	212.46	212.52	212.42	212.47	2900.0
2015-05-28 06:30:00	SPY	ETF	212.45	212.48	212.35	212.38	16426.0
2015-05-28 07:00:00	SPY	ETF	212.44	212.51	212.32	212.33	95534.0
2015-05-28 07:30:00	SPY	ETF	212.35	212.37	212.11	212.19	330061.0
2015-05-28 08:00:00	SPY	ETF	212.48	212.5	212.09	212.12	286955.0
2015-05-28 08:30:00	SPY	ETF	212.13	212.34	212.1	212.19	366470.0
2015-05-28 09:00:00	SPY	ETF	212.19	212.36	212.15	212.34	328676.0
2015-05-28 09:30:00	SPY	ETF	212.33	212.59	211.82	211.85	11853724.0
2015-05-28 10:00:00	SPY	ETF	211.87	212.21	211.78	212.03	6855397.0
2015-05-28 10:30:00	SPY	ETF	212.02	212.06	211.63	211.88	5124949.0
2015-05-28 11:00:00	SPY	ETF	211.88	212.34	211.82	212.16	5636731.0
2015-05-28 11:30:00	SPY	ETF	212.15	212.26	211.66	211.84	4680368.0
2015-05-28 12:00:00	SPY	ETF	211.84	212.15	211.72	212.14	3235308.0
2015-05-28 12:30:00	SPY	ETF	212.13	212.14	211.75	211.89	5380974.0
2015-05-28 13:00:00	SPY	ETF	211.89	212.195	211.84	211.99	4152016.0
2015-05-28 13:30:00	SPY	ETF	211.98	212.26	211.86	212.1	2453926.0
2015-05-28 14:00:00	SPY	ETF	212.095	212.48	212.0	212.4599	2764975.0
2015-05-28 14:30:00	SPY	ETF	212.4501	212.53	212.36	212.45	2327718.0
2015-05-28 15:00:00	SPY	ETF	212.45	212.58	212.3	212.34	3682835.0
2015-05-28 15:30:00	SPY	ETF	212.335	212.57	212.33	212.49	8148902.0
2015-05-28 16:00:00	SPY	ETF	212.48	212.79	212.37	212.76	3434349.0
2015-05-28 16:30:00	SPY	ETF	212.75	212.81	212.74	212.81	1325241.0
2015-05-28 17:00:00	SPY	ETF	212.81	212.82	212.74	212.77	82031.0
2015-05-28 17:30:00	SPY	ETF	212.75	212.78	212.74	212.74	16041.0
2015-05-28 18:00:00	SPY	ETF	212.75	212.75	212.69	212.72	48711.0
2015-05-28 18:30:00	SPY	ETF	212.74	212.75	212.71	212.72	6753.0
2015-05-28 19:00:00	SPY	ETF	212.73	212.74	212.68	212.71	16714.0
2015-05-28 19:30:00	SPY	ETF	212.719	212.76	212.7	212.73	33340.0
2015-05-28 06:30:00	QQQ	ETF	110.77	110.77	110.73	110.76	20500.0
2015-05-28 07:00:00	QQQ	ETF	110.8	110.83	110.73	110.75	15979.0
2015-05-28 07:30:00	QQQ	ETF	110.75	110.76	110.65	110.73	22929.0
2015-05-28 08:00:00	QQQ	ETF	110.72	110.83	110.62	110.66	31242.0
2015-05-28 08:30:00	QQQ	ETF	110.69	110.761	110.68	110.72	44801.0
2015-05-28 09:00:00	QQQ	ETF	110.72	110.81	110.7	110.74	119497.0
2015-05-28 09:30:00	QQQ	ETF	110.75	111.01	110.43	110.48	3822556.0
2015-05-28 10:00:00	QQQ	ETF	110.49	110.7	110.39	110.63	1766576.0
2015-05-28 10:30:00	QQQ	ETF	110.62	110.679	110.37	110.5956	1041793.0
2015-05-28 11:00:00	QQQ	ETF	110.595	110.81	110.52	110.72	1139353.0
2015-05-28 11:30:00	QQQ	ETF	110.715	110.77	110.43	110.54	899206.0
2015-05-28 12:00:00	QQQ	ETF	110.54	110.71	110.48	110.7	497902.0
2015-05-28 12:30:00	QQQ	ETF	110.7039	110.71	110.5	110.53	502836.0
2015-05-28 13:00:00	QQQ	ETF	110.52	110.67	110.5	110.57	430858.0
2015-05-28 13:30:00	QQQ	ETF	110.57	110.69	110.5	110.59	528181.0
2015-05-28 14:00:00	QQQ	ETF	110.6	110.78	110.56	110.7614	483466.0
2015-05-28 14:30:00	QQQ	ETF	110.765	110.81	110.69	110.72	536107.0
2015-05-28 15:00:00	QQQ	ETF	110.73	110.8	110.6139	110.639	821052.0

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

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