PREVIEW / etf_30min / 2014-11-14

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-11-14.parquet
  size:    354 KB
  rows:    11,918

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-14 04:00:00	SPY	ETF	203.97	204.38	203.97	204.25	7464.0
2014-11-14 04:30:00	SPY	ETF	204.19	204.3	204.12	204.3	16404.0
2014-11-14 05:00:00	SPY	ETF	204.35	204.35	204.26	204.28	2462.0
2014-11-14 05:30:00	SPY	ETF	204.24	204.26	204.13	204.14	6028.0
2014-11-14 06:00:00	SPY	ETF	204.18	204.18	203.96	203.96	4132.0
2014-11-14 06:30:00	SPY	ETF	203.91	203.99	203.84	203.89	34298.0
2014-11-14 07:00:00	SPY	ETF	203.92	204.02	203.88	203.96	77169.0
2014-11-14 07:30:00	SPY	ETF	203.99	203.99	203.79	203.98	87355.0
2014-11-14 08:00:00	SPY	ETF	203.92	204.15	203.92	204.06	318932.0
2014-11-14 08:30:00	SPY	ETF	204.1	204.29	203.96	204.07	801218.0
2014-11-14 09:00:00	SPY	ETF	204.08	204.12	203.96	204.11	579481.0
2014-11-14 09:30:00	SPY	ETF	204.1	204.28	203.86	204.1	8134097.0
2014-11-14 10:00:00	SPY	ETF	204.1	204.49	203.99	204.07	6681315.0
2014-11-14 10:30:00	SPY	ETF	204.07	204.34	203.76	204.28	7102787.0
2014-11-14 11:00:00	SPY	ETF	204.29	204.38	204.15	204.195	4715594.0
2014-11-14 11:30:00	SPY	ETF	204.2	204.33	204.03	204.16	4517387.0
2014-11-14 12:00:00	SPY	ETF	204.16	204.25	204.02	204.18	2820446.0
2014-11-14 12:30:00	SPY	ETF	204.18	204.27	204.08	204.09	2939727.0
2014-11-14 13:00:00	SPY	ETF	204.08	204.16	203.98	204.04	2092265.0
2014-11-14 13:30:00	SPY	ETF	204.04	204.12	203.85	203.855	3591798.0
2014-11-14 14:00:00	SPY	ETF	203.86	204.02	203.72	203.98	3896981.0
2014-11-14 14:30:00	SPY	ETF	203.98	204.22	203.88	203.95	2256922.0
2014-11-14 15:00:00	SPY	ETF	203.95	204.1695	203.94	204.099	5138822.0
2014-11-14 15:30:00	SPY	ETF	204.1	204.2599	204.04	204.25	10672747.0
2014-11-14 16:00:00	SPY	ETF	204.25	204.35	203.9771	204.25	6391637.0
2014-11-14 16:30:00	SPY	ETF	204.25	204.36	204.24	204.36	6680577.0
2014-11-14 17:00:00	SPY	ETF	204.36	204.43	204.34	204.37	122430.0
2014-11-14 17:30:00	SPY	ETF	204.38	204.41	204.37	204.38	36278.0
2014-11-14 18:00:00	SPY	ETF	204.38	204.44	204.37	204.44	36742.0
2014-11-14 18:30:00	SPY	ETF	204.43	204.43	204.4	204.41	11448.0
2014-11-14 19:00:00	SPY	ETF	204.42	204.46	204.4	204.43	7604.0
2014-11-14 19:30:00	SPY	ETF	204.43	204.53	204.39	204.52	25540.0
2014-11-14 04:30:00	QQQ	ETF	102.8	102.9	102.8	102.9	7500.0
2014-11-14 05:30:00	QQQ	ETF	102.9	102.9	102.87	102.87	10600.0
2014-11-14 06:00:00	QQQ	ETF	102.88	102.88	102.88	102.88	500.0
2014-11-14 06:30:00	QQQ	ETF	102.78	102.84	102.77	102.77	8100.0
2014-11-14 07:00:00	QQQ	ETF	102.78	102.85	102.78	102.84	10376.0
2014-11-14 07:30:00	QQQ	ETF	102.79	102.79	102.73	102.75	42469.0
2014-11-14 08:00:00	QQQ	ETF	102.78	102.85	102.75	102.83	71601.0
2014-11-14 08:30:00	QQQ	ETF	102.84	102.93	102.76	102.83	67061.0
2014-11-14 09:00:00	QQQ	ETF	102.82	102.86	102.75	102.85	233128.0
2014-11-14 09:30:00	QQQ	ETF	102.87	102.97	102.59	102.77	2993014.0
2014-11-14 10:00:00	QQQ	ETF	102.77	103.07	102.63	102.72	1910464.0
2014-11-14 10:30:00	QQQ	ETF	102.71	103.09	102.53	103.06	1941679.0
2014-11-14 11:00:00	QQQ	ETF	103.075	103.17	103.04	103.09	1017255.0
2014-11-14 11:30:00	QQQ	ETF	103.08	103.14	102.97	103.06	682083.0
2014-11-14 12:00:00	QQQ	ETF	103.07	103.14	102.99	103.08	646867.0
2014-11-14 12:30:00	QQQ	ETF	103.08	103.16	103.07	103.08	467654.0
2014-11-14 13:00:00	QQQ	ETF	103.08	103.16	102.99	103.055	691429.0
2014-11-14 13:30:00	QQQ	ETF	103.05	103.1075	102.93	102.94	605908.0

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

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