PREVIEW / etf_30min / 2014-10-29

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-10-29.parquet
  size:    366 KB
  rows:    12,274

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-29 04:00:00	SPY	ETF	198.44	198.58	198.43	198.58	2026.0
2014-10-29 04:30:00	SPY	ETF	198.4	198.43	198.24	198.42	11705.0
2014-10-29 05:00:00	SPY	ETF	198.35	198.51	198.34	198.49	11625.0
2014-10-29 05:30:00	SPY	ETF	198.55	198.72	198.55	198.57	9895.0
2014-10-29 06:00:00	SPY	ETF	198.54	198.54	198.39	198.4	24116.0
2014-10-29 06:30:00	SPY	ETF	198.48	198.54	198.21	198.21	139428.0
2014-10-29 07:00:00	SPY	ETF	198.27	198.32	198.18	198.18	99819.0
2014-10-29 07:30:00	SPY	ETF	198.17	198.3	198.08	198.3	145946.0
2014-10-29 08:00:00	SPY	ETF	198.29	198.43	198.11	198.43	370227.0
2014-10-29 08:30:00	SPY	ETF	198.44	198.46	198.34	198.39	304878.0
2014-10-29 09:00:00	SPY	ETF	198.4	198.62	198.14	198.55	833887.0
2014-10-29 09:30:00	SPY	ETF	198.55	199.12	198.47	199.09	11398538.0
2014-10-29 10:00:00	SPY	ETF	199.085	199.12	198.41	198.54	10780481.0
2014-10-29 10:30:00	SPY	ETF	198.54	198.8	198.22	198.35	8995103.0
2014-10-29 11:00:00	SPY	ETF	198.35	198.66	198.26	198.57	6666863.0
2014-10-29 11:30:00	SPY	ETF	198.57	198.59	198.33	198.47	3324819.0
2014-10-29 12:00:00	SPY	ETF	198.46	198.47	198.02	198.02	5724575.0
2014-10-29 12:30:00	SPY	ETF	198.03	198.195	197.96	198.1	4708328.0
2014-10-29 13:00:00	SPY	ETF	198.109	198.17	198.0	198.12	3745105.0
2014-10-29 13:30:00	SPY	ETF	198.12	198.145	197.72	198.09	7039161.0
2014-10-29 14:00:00	SPY	ETF	198.07	198.085	196.8	197.87	28066175.0
2014-10-29 14:30:00	SPY	ETF	197.87	198.05	197.21	197.71	13830049.0
2014-10-29 15:00:00	SPY	ETF	197.71	197.79	196.98	197.69	10572515.0
2014-10-29 15:30:00	SPY	ETF	197.695	198.42	197.69	198.14	15574806.0
2014-10-29 16:00:00	SPY	ETF	198.13	198.189	197.77	197.77	8538502.0
2014-10-29 16:30:00	SPY	ETF	197.8	197.86	197.73	197.76	531101.0
2014-10-29 17:00:00	SPY	ETF	197.76	198.1797	197.69	198.1797	158342.0
2014-10-29 17:30:00	SPY	ETF	197.76	197.78	197.74	197.74	96587.0
2014-10-29 18:00:00	SPY	ETF	197.75	197.92	197.62	197.92	117952.0
2014-10-29 18:30:00	SPY	ETF	197.92	197.94	197.87	197.9	23310.0
2014-10-29 19:00:00	SPY	ETF	197.86	197.87	197.82	197.85	9210.0
2014-10-29 19:30:00	SPY	ETF	197.85	197.85	197.64	197.65	51286.0
2014-10-29 04:00:00	QQQ	ETF	99.81	99.87	99.81	99.87	26200.0
2014-10-29 04:30:00	QQQ	ETF	99.74	99.74	99.74	99.74	1000.0
2014-10-29 05:00:00	QQQ	ETF	99.81	99.93	99.81	99.91	7400.0
2014-10-29 05:30:00	QQQ	ETF	99.93	99.99	99.91	99.99	7000.0
2014-10-29 06:00:00	QQQ	ETF	99.98	99.98	99.88	99.89	2327.0
2014-10-29 06:30:00	QQQ	ETF	99.9	99.98	99.81	99.81	10400.0
2014-10-29 07:00:00	QQQ	ETF	99.83	99.86	99.78	99.78	15021.0
2014-10-29 07:30:00	QQQ	ETF	99.77	99.81	99.72	99.79	19272.0
2014-10-29 08:00:00	QQQ	ETF	99.81	99.92	99.78	99.92	93970.0
2014-10-29 08:30:00	QQQ	ETF	99.92	100.01	99.81	99.86	196108.0
2014-10-29 09:00:00	QQQ	ETF	99.85	100.02	99.82	99.83	309242.0
2014-10-29 09:30:00	QQQ	ETF	99.84	100.12	99.75	100.065	4058874.0
2014-10-29 10:00:00	QQQ	ETF	100.065	100.09	99.71	99.815	3421755.0
2014-10-29 10:30:00	QQQ	ETF	99.82	99.93	99.73	99.789	1867341.0
2014-10-29 11:00:00	QQQ	ETF	99.79	99.97	99.79	99.89	995688.0
2014-10-29 11:30:00	QQQ	ETF	99.88	99.9	99.73	99.81	1007829.0
2014-10-29 12:00:00	QQQ	ETF	99.815	99.83	99.57	99.58	1348822.0
2014-10-29 12:30:00	QQQ	ETF	99.58	99.72	99.555	99.62	1181668.0

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

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