PREVIEW / etf_30min / 2014-11-10

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-11-10.parquet
  size:    360 KB
  rows:    12,254

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-11-10 04:00:00	SPY	ETF	203.25	203.26	203.25	203.25	430.0
2014-11-10 04:30:00	SPY	ETF	203.03	203.21	203.03	203.2	8989.0
2014-11-10 05:00:00	SPY	ETF	203.25	203.43	203.25	203.43	30655.0
2014-11-10 05:30:00	SPY	ETF	203.48	203.48	203.28	203.35	7729.0
2014-11-10 06:00:00	SPY	ETF	203.29	203.36	203.24	203.29	16010.0
2014-11-10 06:30:00	SPY	ETF	203.3	203.42	203.3	203.4	27580.0
2014-11-10 07:00:00	SPY	ETF	203.44	203.45	203.27	203.32	35243.0
2014-11-10 07:30:00	SPY	ETF	203.34	203.5	203.34	203.41	159797.0
2014-11-10 08:00:00	SPY	ETF	203.42	203.49	203.35	203.43	147902.0
2014-11-10 08:30:00	SPY	ETF	203.43	203.43	203.27	203.33	312619.0
2014-11-10 09:00:00	SPY	ETF	203.32	203.43	203.28	203.39	446856.0
2014-11-10 09:30:00	SPY	ETF	203.38	203.53	203.13	203.35	9700462.0
2014-11-10 10:00:00	SPY	ETF	203.34	203.48	203.17	203.28	6572427.0
2014-11-10 10:30:00	SPY	ETF	203.27	203.93	203.26	203.84	6127445.0
2014-11-10 11:00:00	SPY	ETF	203.85	203.89	203.72	203.89	3734512.0
2014-11-10 11:30:00	SPY	ETF	203.9	204.04	203.76	203.81	4865757.0
2014-11-10 12:00:00	SPY	ETF	203.815	203.8599	203.66	203.7399	2567416.0
2014-11-10 12:30:00	SPY	ETF	203.735	203.81	203.65	203.8	2345425.0
2014-11-10 13:00:00	SPY	ETF	203.79	203.89	203.71	203.865	1715275.0
2014-11-10 13:30:00	SPY	ETF	203.86	203.93	203.59	203.6475	2062339.0
2014-11-10 14:00:00	SPY	ETF	203.65	203.88	203.61	203.83	1872321.0
2014-11-10 14:30:00	SPY	ETF	203.825	203.88	203.7	203.87	2063012.0
2014-11-10 15:00:00	SPY	ETF	203.87	203.97	203.825	203.85	3693679.0
2014-11-10 15:30:00	SPY	ETF	203.845	204.0	203.75	203.97	9290612.0
2014-11-10 16:00:00	SPY	ETF	203.96	204.04	203.333	203.98	4927089.0
2014-11-10 16:30:00	SPY	ETF	203.97	203.99	203.92	203.98	1117195.0
2014-11-10 17:00:00	SPY	ETF	203.99	204.02	203.93	203.93	65380.0
2014-11-10 17:30:00	SPY	ETF	203.96	203.98	203.9	203.92	92493.0
2014-11-10 18:00:00	SPY	ETF	203.92	203.93	203.78	203.83	206541.0
2014-11-10 18:30:00	SPY	ETF	203.84	203.84	203.79	203.79	69405.0
2014-11-10 19:00:00	SPY	ETF	203.8	203.9	203.76	203.87	43366.0
2014-11-10 19:30:00	SPY	ETF	203.87	203.92	203.82	203.9	28293.0
2014-11-10 05:00:00	QQQ	ETF	101.66	101.66	101.66	101.66	3000.0
2014-11-10 05:30:00	QQQ	ETF	101.71	101.71	101.57	101.57	8000.0
2014-11-10 06:00:00	QQQ	ETF	101.56	101.62	101.56	101.57	17233.0
2014-11-10 06:30:00	QQQ	ETF	101.6	101.66	101.6	101.65	7400.0
2014-11-10 07:00:00	QQQ	ETF	101.65	101.69	101.65	101.67	44232.0
2014-11-10 07:30:00	QQQ	ETF	101.68	101.72	101.68	101.71	101851.0
2014-11-10 08:00:00	QQQ	ETF	101.69	101.73	101.4	101.68	26614.0
2014-11-10 08:30:00	QQQ	ETF	101.67	101.67	101.61	101.67	20892.0
2014-11-10 09:00:00	QQQ	ETF	101.65	101.7	101.62	101.65	111192.0
2014-11-10 09:30:00	QQQ	ETF	101.64	101.68	101.38	101.505	2610102.0
2014-11-10 10:00:00	QQQ	ETF	101.51	101.7	101.49	101.64	1143913.0
2014-11-10 10:30:00	QQQ	ETF	101.65	102.0	101.63	101.92	1897231.0
2014-11-10 11:00:00	QQQ	ETF	101.93	102.03	101.88	102.03	1039139.0
2014-11-10 11:30:00	QQQ	ETF	102.03	102.09	101.92	101.965	1085665.0
2014-11-10 12:00:00	QQQ	ETF	101.97	101.9872	101.825	101.88	977165.0
2014-11-10 12:30:00	QQQ	ETF	101.88	101.91	101.8	101.87	410324.0
2014-11-10 13:00:00	QQQ	ETF	101.86	101.949	101.82	101.91	472575.0
2014-11-10 13:30:00	QQQ	ETF	101.915	101.97	101.825	101.86	435456.0

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

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