PREVIEW / etf_30min / 2016-02-22

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-02-22.parquet
  size:    390 KB
  rows:    13,352

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-02-22 04:00:00	SPY	ETF	193.65	194.03	193.5	193.98	30980.0
2016-02-22 04:30:00	SPY	ETF	194.0	194.43	193.96	194.43	44425.0
2016-02-22 05:00:00	SPY	ETF	194.39	194.43	194.33	194.33	14417.0
2016-02-22 05:30:00	SPY	ETF	194.28	194.3	194.11	194.15	64439.0
2016-02-22 06:00:00	SPY	ETF	194.18	194.37	194.17	194.37	28483.0
2016-02-22 06:30:00	SPY	ETF	194.27	194.33	194.14	194.2	67760.0
2016-02-22 07:00:00	SPY	ETF	194.2	194.2	193.99	194.1	144735.0
2016-02-22 07:30:00	SPY	ETF	194.08	194.11	193.84	194.03	130282.0
2016-02-22 08:00:00	SPY	ETF	194.0	194.24	193.01	194.09	530664.0
2016-02-22 08:30:00	SPY	ETF	194.07	194.23	193.97	194.21	461587.0
2016-02-22 09:00:00	SPY	ETF	194.21	194.22	193.87	193.88	870866.0
2016-02-22 09:30:00	SPY	ETF	193.87	194.62	193.79	194.52	13366644.0
2016-02-22 10:00:00	SPY	ETF	194.52	194.87	194.41	194.54	9586603.0
2016-02-22 10:30:00	SPY	ETF	194.54	194.72	194.27	194.345	5389774.0
2016-02-22 11:00:00	SPY	ETF	194.3389	194.56	194.17	194.49	4703162.0
2016-02-22 11:30:00	SPY	ETF	194.49	194.56	194.31	194.53	2937990.0
2016-02-22 12:00:00	SPY	ETF	194.53	194.535	194.34	194.4907	2600741.0
2016-02-22 12:30:00	SPY	ETF	194.5	194.71	194.28	194.33	4401635.0
2016-02-22 13:00:00	SPY	ETF	194.3299	194.52	194.28	194.48	2252823.0
2016-02-22 13:30:00	SPY	ETF	194.49	194.95	194.48	194.85	4735914.0
2016-02-22 14:00:00	SPY	ETF	194.8475	194.87	194.4	194.57	4566230.0
2016-02-22 14:30:00	SPY	ETF	194.57	194.59	194.33	194.47	3877683.0
2016-02-22 15:00:00	SPY	ETF	194.47	194.63	194.2	194.49	6783041.0
2016-02-22 15:30:00	SPY	ETF	194.5	194.8	194.46	194.79	20393502.0
2016-02-22 16:00:00	SPY	ETF	194.77	194.8129	194.13	194.17	7458400.0
2016-02-22 16:30:00	SPY	ETF	194.14	194.83	193.91	193.92	1118867.0
2016-02-22 17:00:00	SPY	ETF	193.96	194.07	193.82	194.02	318650.0
2016-02-22 17:30:00	SPY	ETF	194.0	194.1	193.99	194.0	232039.0
2016-02-22 18:00:00	SPY	ETF	194.02	194.14	193.91	194.14	116966.0
2016-02-22 18:30:00	SPY	ETF	194.14	194.15	193.93	193.93	50749.0
2016-02-22 19:00:00	SPY	ETF	194.0	194.11	193.93	194.09	45110.0
2016-02-22 19:30:00	SPY	ETF	194.08	194.1	193.85	193.92	58569.0
2016-02-22 04:00:00	QQQ	ETF	102.36	102.82	102.36	102.82	3075.0
2016-02-22 04:30:00	QQQ	ETF	102.82	103.0	102.8	103.0	4799.0
2016-02-22 05:00:00	QQQ	ETF	102.99	102.99	102.99	102.99	600.0
2016-02-22 05:30:00	QQQ	ETF	102.87	102.87	102.87	102.87	300.0
2016-02-22 06:00:00	QQQ	ETF	102.88	102.88	102.88	102.88	200.0
2016-02-22 06:30:00	QQQ	ETF	102.91	102.96	102.85	102.86	25220.0
2016-02-22 07:00:00	QQQ	ETF	102.81	102.81	102.74	102.8	26802.0
2016-02-22 07:30:00	QQQ	ETF	102.78	102.8	102.69	102.74	22293.0
2016-02-22 08:00:00	QQQ	ETF	102.75	102.83	102.67	102.69	115623.0
2016-02-22 08:30:00	QQQ	ETF	102.74	102.74	102.64	102.69	60892.0
2016-02-22 09:00:00	QQQ	ETF	102.7	102.7	102.52	102.53	173103.0
2016-02-22 09:30:00	QQQ	ETF	102.53	103.07	102.48	103.03	4285642.0
2016-02-22 10:00:00	QQQ	ETF	103.02	103.2199	102.8539	102.92	2384985.0
2016-02-22 10:30:00	QQQ	ETF	102.93	103.03	102.72	102.83	991672.0
2016-02-22 11:00:00	QQQ	ETF	102.83	103.13	102.75	103.0885	1216158.0
2016-02-22 11:30:00	QQQ	ETF	103.09	103.19	102.98	103.17	874757.0
2016-02-22 12:00:00	QQQ	ETF	103.17	103.17	103.01	103.131	623992.0
2016-02-22 12:30:00	QQQ	ETF	103.15	103.29	102.98	103.01	752176.0

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

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