PREVIEW / etf_30min / 2014-05-20

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-05-20.parquet
  size:    328 KB
  rows:    11,163

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-05-20 04:00:00	SPY	ETF	188.83	188.83	188.73	188.76	1687.0
2014-05-20 04:30:00	SPY	ETF	188.58	188.6	188.46	188.56	10984.0
2014-05-20 05:00:00	SPY	ETF	188.66	188.7	188.66	188.68	360.0
2014-05-20 05:30:00	SPY	ETF	188.67	188.67	188.61	188.62	1601.0
2014-05-20 06:00:00	SPY	ETF	188.59	188.75	188.59	188.7	6697.0
2014-05-20 06:30:00	SPY	ETF	188.69	188.71	188.59	188.71	13671.0
2014-05-20 07:00:00	SPY	ETF	188.68	188.9	188.68	188.84	24087.0
2014-05-20 07:30:00	SPY	ETF	188.88	188.91	188.75	188.79	108431.0
2014-05-20 08:00:00	SPY	ETF	188.77	188.9	188.73	188.84	115038.0
2014-05-20 08:30:00	SPY	ETF	188.83	188.83	188.63	188.64	305884.0
2014-05-20 09:00:00	SPY	ETF	188.64	188.64	188.55	188.64	464203.0
2014-05-20 09:30:00	SPY	ETF	188.645	188.67	188.0	188.08	11242294.0
2014-05-20 10:00:00	SPY	ETF	188.09	188.41	188.0	188.07	7107370.0
2014-05-20 10:30:00	SPY	ETF	188.08	188.58	188.04	188.545	8558397.0
2014-05-20 11:00:00	SPY	ETF	188.55	188.58	188.3	188.3	4723068.0
2014-05-20 11:30:00	SPY	ETF	188.3	188.588	188.26	188.33	4235811.0
2014-05-20 12:00:00	SPY	ETF	188.33	188.34	187.68	187.808	8669996.0
2014-05-20 12:30:00	SPY	ETF	187.81	187.869	187.61	187.8	4463228.0
2014-05-20 13:00:00	SPY	ETF	187.8	187.805	187.34	187.56	6733318.0
2014-05-20 13:30:00	SPY	ETF	187.56	187.57	187.07	187.08	6628228.0
2014-05-20 14:00:00	SPY	ETF	187.08	187.53	187.075	187.38	5079103.0
2014-05-20 14:30:00	SPY	ETF	187.38	187.4	187.16	187.28	6346431.0
2014-05-20 15:00:00	SPY	ETF	187.27	187.63	187.22	187.5	6238817.0
2014-05-20 15:30:00	SPY	ETF	187.51	187.89	187.5	187.53	14984477.0
2014-05-20 16:00:00	SPY	ETF	187.51	188.7948	187.37	187.39	6504569.0
2014-05-20 16:30:00	SPY	ETF	187.39	188.7948	187.39	187.46	2919400.0
2014-05-20 17:00:00	SPY	ETF	187.46	187.47	187.41	187.44	1074910.0
2014-05-20 17:30:00	SPY	ETF	187.42	187.47	187.41	187.43	17529.0
2014-05-20 18:00:00	SPY	ETF	187.43	187.43	187.36	187.36	47547.0
2014-05-20 18:30:00	SPY	ETF	187.39	187.39	187.33	187.33	15318.0
2014-05-20 19:00:00	SPY	ETF	187.33	187.34	187.25	187.28	33409.0
2014-05-20 19:30:00	SPY	ETF	187.28	187.32	187.28	187.31	36763.0
2014-05-20 04:00:00	QQQ	ETF	88.28	88.42	88.28	88.29	5320.0
2014-05-20 06:00:00	QQQ	ETF	88.29	88.29	88.29	88.29	200.0
2014-05-20 07:00:00	QQQ	ETF	88.33	88.4	88.32	88.4	900.0
2014-05-20 07:30:00	QQQ	ETF	88.4	88.41	88.38	88.38	42000.0
2014-05-20 08:00:00	QQQ	ETF	88.37	88.47	88.36	88.42	78800.0
2014-05-20 08:30:00	QQQ	ETF	88.38	88.38	88.3	88.33	22400.0
2014-05-20 09:00:00	QQQ	ETF	88.3	88.31	88.25	88.28	52072.0
2014-05-20 09:30:00	QQQ	ETF	88.28	88.4	87.99	88.06	4104361.0
2014-05-20 10:00:00	QQQ	ETF	88.06	88.36	87.99	88.15	2655869.0
2014-05-20 10:30:00	QQQ	ETF	88.155	88.44	88.11	88.42	1812488.0
2014-05-20 11:00:00	QQQ	ETF	88.42	88.44	88.31	88.33	1118685.0
2014-05-20 11:30:00	QQQ	ETF	88.34	88.6	88.31	88.49	2175149.0
2014-05-20 12:00:00	QQQ	ETF	88.495	88.51	88.08	88.15	2906307.0
2014-05-20 12:30:00	QQQ	ETF	88.16	88.18	88.031	88.15	1395363.0
2014-05-20 13:00:00	QQQ	ETF	88.14	88.14	87.83	87.96	2161291.0
2014-05-20 13:30:00	QQQ	ETF	87.96	87.98	87.64	87.66	1812200.0
2014-05-20 14:00:00	QQQ	ETF	87.665	87.9349	87.645	87.85	1552807.0
2014-05-20 14:30:00	QQQ	ETF	87.85	87.87	87.67	87.735	1723793.0

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

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