PREVIEW / etf_30min / 2014-10-27

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-10-27.parquet
  size:    357 KB
  rows:    12,179

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-10-27 05:00:00	SPY	ETF	196.9	196.98	196.3	196.34	30466.0
2014-10-27 05:30:00	SPY	ETF	196.48	196.48	196.0	196.28	10780.0
2014-10-27 06:00:00	SPY	ETF	196.19	196.28	195.93	196.28	299743.0
2014-10-27 06:30:00	SPY	ETF	196.21	196.26	196.01	196.04	51418.0
2014-10-27 07:00:00	SPY	ETF	196.09	196.34	196.03	196.29	163611.0
2014-10-27 07:30:00	SPY	ETF	196.21	196.31	196.09	196.18	234684.0
2014-10-27 08:00:00	SPY	ETF	196.18	197.02	196.06	196.13	390457.0
2014-10-27 08:30:00	SPY	ETF	196.12	196.15	195.62	195.74	1048710.0
2014-10-27 09:00:00	SPY	ETF	195.75	195.75	195.38	195.74	982945.0
2014-10-27 09:30:00	SPY	ETF	195.73	195.84	195.14	195.39	12758480.0
2014-10-27 10:00:00	SPY	ETF	195.395	195.82	195.03	195.68	7787262.0
2014-10-27 10:30:00	SPY	ETF	195.69	196.25	195.42	196.01	7505288.0
2014-10-27 11:00:00	SPY	ETF	196.01	196.45	195.89	196.09	5491257.0
2014-10-27 11:30:00	SPY	ETF	196.105	196.24	195.48	195.605	4986427.0
2014-10-27 12:00:00	SPY	ETF	195.6	196.01	195.5701	195.66	4009746.0
2014-10-27 12:30:00	SPY	ETF	195.66	195.97	195.54	195.88	3921247.0
2014-10-27 13:00:00	SPY	ETF	195.88	196.34	195.88	196.08	5340578.0
2014-10-27 13:30:00	SPY	ETF	196.09	196.14	195.8	195.93	3117477.0
2014-10-27 14:00:00	SPY	ETF	195.93	196.15	195.79	195.944	2742365.0
2014-10-27 14:30:00	SPY	ETF	195.94	196.05	195.71	195.84	3052445.0
2014-10-27 15:00:00	SPY	ETF	195.84	196.1	195.83	195.885	4013620.0
2014-10-27 15:30:00	SPY	ETF	195.885	196.28	195.8	196.11	9046916.0
2014-10-27 16:00:00	SPY	ETF	196.11	196.42	196.1	196.34	3047877.0
2014-10-27 16:30:00	SPY	ETF	196.34	196.4	196.1	196.33	583799.0
2014-10-27 17:00:00	SPY	ETF	196.34	196.36	196.3	196.34	44553.0
2014-10-27 17:30:00	SPY	ETF	196.33	196.39	196.33	196.37	16891.0
2014-10-27 18:00:00	SPY	ETF	196.37	196.46	196.32	196.43	89444.0
2014-10-27 18:30:00	SPY	ETF	196.43	196.43	196.3	196.3	50994.0
2014-10-27 19:00:00	SPY	ETF	196.3	196.38	196.26	196.38	42937.0
2014-10-27 19:30:00	SPY	ETF	196.37	196.4	196.32	196.38	11829.0
2014-10-27 04:00:00	QQQ	ETF	98.88	98.92	98.78	98.78	10800.0
2014-10-27 04:30:00	QQQ	ETF	98.74	98.74	98.74	98.74	100.0
2014-10-27 05:00:00	QQQ	ETF	98.64	98.64	98.64	98.64	200.0
2014-10-27 05:30:00	QQQ	ETF	98.71	98.71	98.47	98.6	9800.0
2014-10-27 06:00:00	QQQ	ETF	98.6	98.6	98.44	98.58	10900.0
2014-10-27 06:30:00	QQQ	ETF	98.57	98.57	98.44	98.45	4200.0
2014-10-27 07:00:00	QQQ	ETF	98.49	98.63	98.47	98.54	25269.0
2014-10-27 07:30:00	QQQ	ETF	98.5	98.58	98.49	98.57	18200.0
2014-10-27 08:00:00	QQQ	ETF	98.52	99.03	98.52	98.55	108352.0
2014-10-27 08:30:00	QQQ	ETF	98.57	98.57	98.35	98.42	158777.0
2014-10-27 09:00:00	QQQ	ETF	98.41	98.43	98.26	98.41	396557.0
2014-10-27 09:30:00	QQQ	ETF	98.4	98.62	98.14	98.1901	4288695.0
2014-10-27 10:00:00	QQQ	ETF	98.19	98.54	98.02	98.43	3595634.0
2014-10-27 10:30:00	QQQ	ETF	98.43	98.77	98.34	98.6	2206430.0
2014-10-27 11:00:00	QQQ	ETF	98.6	98.83	98.51	98.68	1573838.0
2014-10-27 11:30:00	QQQ	ETF	98.68	98.74	98.385	98.449	1553694.0
2014-10-27 12:00:00	QQQ	ETF	98.44	98.6	98.41	98.47	856402.0
2014-10-27 12:30:00	QQQ	ETF	98.47	98.68	98.43	98.65	1024052.0
2014-10-27 13:00:00	QQQ	ETF	98.65	98.87	98.65	98.69	1640745.0
2014-10-27 13:30:00	QQQ	ETF	98.69	98.739	98.53	98.58	1651935.0

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

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