PREVIEW / etf_30min / 2014-04-02

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-04-02.parquet
  size:    333 KB
  rows:    11,456

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
2014-04-02 04:00:00	SPY	ETF	188.49	188.58	188.49	188.58	15600.0
2014-04-02 04:30:00	SPY	ETF	188.54	188.55	188.44	188.55	3346.0
2014-04-02 05:00:00	SPY	ETF	188.53	188.61	188.53	188.55	20558.0
2014-04-02 05:30:00	SPY	ETF	188.61	188.62	188.54	188.55	15478.0
2014-04-02 06:00:00	SPY	ETF	188.56	188.64	188.5	188.5	16821.0
2014-04-02 06:30:00	SPY	ETF	188.46	188.49	188.42	188.44	10630.0
2014-04-02 07:00:00	SPY	ETF	188.43	188.54	188.43	188.48	42286.0
2014-04-02 07:30:00	SPY	ETF	188.44	188.5	188.23	188.29	99621.0
2014-04-02 08:00:00	SPY	ETF	188.43	188.51	188.21	188.39	389608.0
2014-04-02 08:30:00	SPY	ETF	188.38	188.38	188.23	188.35	248845.0
2014-04-02 09:00:00	SPY	ETF	188.35	188.49	188.29	188.49	340446.0
2014-04-02 09:30:00	SPY	ETF	188.5	188.59	188.14	188.28	10584368.0
2014-04-02 10:00:00	SPY	ETF	188.28	188.68	188.28	188.68	8070014.0
2014-04-02 10:30:00	SPY	ETF	188.67	188.825	188.6175	188.775	5027590.0
2014-04-02 11:00:00	SPY	ETF	188.77	188.87	188.56	188.72	4670611.0
2014-04-02 11:30:00	SPY	ETF	188.72	188.82	188.57	188.795	3326404.0
2014-04-02 12:00:00	SPY	ETF	188.8	188.9	188.63	188.82	3178286.0
2014-04-02 12:30:00	SPY	ETF	188.82	188.86	188.72	188.77	2804175.0
2014-04-02 13:00:00	SPY	ETF	188.78	188.79	188.48	188.56	2926661.0
2014-04-02 13:30:00	SPY	ETF	188.555	188.59	188.34	188.49	4474364.0
2014-04-02 14:00:00	SPY	ETF	188.48	188.67	188.45	188.47	5364117.0
2014-04-02 14:30:00	SPY	ETF	188.47	188.7	188.4	188.69	3059786.0
2014-04-02 15:00:00	SPY	ETF	188.7	189.05	188.64	189.049	4859245.0
2014-04-02 15:30:00	SPY	ETF	189.05	189.13	188.86	188.88	12977550.0
2014-04-02 16:00:00	SPY	ETF	188.88	188.93	188.3492	188.82	4539233.0
2014-04-02 16:30:00	SPY	ETF	188.81	188.85	188.7086	188.85	117325.0
2014-04-02 17:00:00	SPY	ETF	188.86	188.86	188.78	188.8	52936.0
2014-04-02 17:30:00	SPY	ETF	188.8	188.84	188.79	188.8	6750.0
2014-04-02 18:00:00	SPY	ETF	188.79	188.79	188.74	188.78	26248.0
2014-04-02 18:30:00	SPY	ETF	188.74	188.77	188.72	188.77	9337.0
2014-04-02 19:00:00	SPY	ETF	188.75	188.76	188.69	188.72	34388.0
2014-04-02 19:30:00	SPY	ETF	188.72	188.74	188.67	188.68	53667.0
2014-04-02 04:00:00	QQQ	ETF	89.43	89.49	89.43	89.49	25500.0
2014-04-02 05:00:00	QQQ	ETF	89.47	89.47	89.47	89.47	13200.0
2014-04-02 05:30:00	QQQ	ETF	89.5	89.5	89.5	89.5	490.0
2014-04-02 06:00:00	QQQ	ETF	89.45	89.46	89.41	89.41	3500.0
2014-04-02 07:00:00	QQQ	ETF	89.36	89.45	89.36	89.43	42715.0
2014-04-02 07:30:00	QQQ	ETF	89.39	89.45	89.27	89.31	76000.0
2014-04-02 08:00:00	QQQ	ETF	89.28	89.41	89.28	89.38	49766.0
2014-04-02 08:30:00	QQQ	ETF	89.34	89.37	89.31	89.33	79910.0
2014-04-02 09:00:00	QQQ	ETF	89.33	89.59	89.33	89.59	132951.0
2014-04-02 09:30:00	QQQ	ETF	89.59	89.68	89.22	89.25	5007620.0
2014-04-02 10:00:00	QQQ	ETF	89.25	89.44	89.1	89.44	3690332.0
2014-04-02 10:30:00	QQQ	ETF	89.44	89.46	89.31	89.44	2236567.0
2014-04-02 11:00:00	QQQ	ETF	89.44	89.5299	89.25	89.34	1499484.0
2014-04-02 11:30:00	QQQ	ETF	89.34	89.43	89.27	89.38	922648.0
2014-04-02 12:00:00	QQQ	ETF	89.39	89.3999	89.23	89.37	1080285.0
2014-04-02 12:30:00	QQQ	ETF	89.36	89.42	89.32	89.382	1761800.0
2014-04-02 13:00:00	QQQ	ETF	89.39	89.39	89.14	89.21	1586144.0
2014-04-02 13:30:00	QQQ	ETF	89.21	89.259	89.035	89.1625	1031947.0

> showing 50 of 11,456 rows — these rows as CSV

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