PREVIEW / etf_30min / 2016-01-27

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-01-27.parquet
  size:    402 KB
  rows:    13,597

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
2016-01-27 04:00:00	SPY	ETF	189.03	189.12	188.83	189.04	26954.0
2016-01-27 04:30:00	SPY	ETF	189.02	189.13	188.62	188.8	7935.0
2016-01-27 05:00:00	SPY	ETF	188.9	188.99	188.66	188.99	9770.0
2016-01-27 05:30:00	SPY	ETF	189.0	189.3	188.81	189.21	8000.0
2016-01-27 06:00:00	SPY	ETF	189.09	189.27	189.0	189.1	3165.0
2016-01-27 06:30:00	SPY	ETF	189.06	189.08	188.67	188.91	66825.0
2016-01-27 07:00:00	SPY	ETF	188.98	189.31	188.87	189.27	147479.0
2016-01-27 07:30:00	SPY	ETF	189.3	189.45	189.13	189.38	336810.0
2016-01-27 08:00:00	SPY	ETF	189.38	189.69	188.88	189.66	514567.0
2016-01-27 08:30:00	SPY	ETF	189.65	189.89	189.48	189.74	583555.0
2016-01-27 09:00:00	SPY	ETF	189.72	189.82	189.55	189.58	779195.0
2016-01-27 09:30:00	SPY	ETF	189.58	189.99	189.33	189.59	9799646.0
2016-01-27 10:00:00	SPY	ETF	189.58	189.69	188.55	188.66	10493978.0
2016-01-27 10:30:00	SPY	ETF	188.67	189.6	188.62	189.22	9435862.0
2016-01-27 11:00:00	SPY	ETF	189.225	189.94	189.02	189.89	6213656.0
2016-01-27 11:30:00	SPY	ETF	189.89	191.24	189.87	191.009	13206328.0
2016-01-27 12:00:00	SPY	ETF	190.995	191.56	190.9	191.115	6360577.0
2016-01-27 12:30:00	SPY	ETF	191.11	191.17	190.76	190.77	6082208.0
2016-01-27 13:00:00	SPY	ETF	190.76	191.09	190.58	190.58	6189948.0
2016-01-27 13:30:00	SPY	ETF	190.59	190.98	190.435	190.96	5296759.0
2016-01-27 14:00:00	SPY	ETF	190.96	191.49	189.13	189.97	28523366.0
2016-01-27 14:30:00	SPY	ETF	189.98	190.07	188.37	188.58	18634001.0
2016-01-27 15:00:00	SPY	ETF	188.57	188.59	187.06	187.7	30027611.0
2016-01-27 15:30:00	SPY	ETF	187.71	188.36	187.51	188.12	22155838.0
2016-01-27 16:00:00	SPY	ETF	188.13	188.3	187.94	188.27	7093172.0
2016-01-27 16:30:00	SPY	ETF	188.25	188.5	188.22	188.39	537973.0
2016-01-27 17:00:00	SPY	ETF	188.36	188.49	188.14	188.49	710219.0
2016-01-27 17:30:00	SPY	ETF	188.53	188.79	188.13	188.57	158493.0
2016-01-27 18:00:00	SPY	ETF	188.59	188.83	188.35	188.57	234862.0
2016-01-27 18:30:00	SPY	ETF	188.54	188.54	187.83	187.92	133412.0
2016-01-27 19:00:00	SPY	ETF	187.95	187.99	187.17	187.67	187191.0
2016-01-27 19:30:00	SPY	ETF	187.65	187.98	187.56	187.79	84173.0
2016-01-27 20:00:00	SPY	ETF	188.1368	188.1368	188.1368	188.1368	90000.0
2016-01-27 04:00:00	QQQ	ETF	102.21	102.23	102.13	102.23	6262.0
2016-01-27 04:30:00	QQQ	ETF	102.24	102.24	101.99	101.99	1500.0
2016-01-27 05:00:00	QQQ	ETF	102.05	102.05	102.05	102.05	100.0
2016-01-27 05:30:00	QQQ	ETF	102.18	102.3	102.18	102.3	7450.0
2016-01-27 06:00:00	QQQ	ETF	102.23	102.26	102.18	102.23	4100.0
2016-01-27 06:30:00	QQQ	ETF	102.25	102.25	102.05	102.13	8750.0
2016-01-27 07:00:00	QQQ	ETF	102.19	102.37	102.11	102.36	3300.0
2016-01-27 07:30:00	QQQ	ETF	102.4	102.52	102.35	102.51	35230.0
2016-01-27 08:00:00	QQQ	ETF	102.52	102.7	102.41	102.69	113114.0
2016-01-27 08:30:00	QQQ	ETF	102.69	102.78	102.6	102.69	208947.0
2016-01-27 09:00:00	QQQ	ETF	102.68	102.72	102.54	102.55	402316.0
2016-01-27 09:30:00	QQQ	ETF	102.55	102.79	102.12	102.1901	4843102.0
2016-01-27 10:00:00	QQQ	ETF	102.19	102.23	101.37	101.43	3790503.0
2016-01-27 10:30:00	QQQ	ETF	101.425	101.89	101.37	101.76	2752576.0
2016-01-27 11:00:00	QQQ	ETF	101.76	102.03	101.63	101.99	1756342.0
2016-01-27 11:30:00	QQQ	ETF	101.99	102.66	101.99	102.551	2659874.0
2016-01-27 12:00:00	QQQ	ETF	102.56	102.99	102.5	102.67	2647444.0

> showing 50 of 13,597 rows — these rows as CSV

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