PREVIEW / etf_30min / 2015-10-08

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-10-08.parquet
  size:    379 KB
  rows:    12,678

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
2015-10-08 04:00:00	SPY	ETF	198.25	198.69	198.14	198.17	16952.0
2015-10-08 04:30:00	SPY	ETF	198.22	198.44	198.1	198.12	36159.0
2015-10-08 05:00:00	SPY	ETF	198.12	198.61	198.01	198.55	43619.0
2015-10-08 05:30:00	SPY	ETF	198.56	198.62	198.27	198.42	24091.0
2015-10-08 06:00:00	SPY	ETF	198.45	198.96	198.45	198.68	71018.0
2015-10-08 06:30:00	SPY	ETF	198.77	198.93	198.51	198.67	95420.0
2015-10-08 07:00:00	SPY	ETF	198.69	198.87	198.59	198.73	118941.0
2015-10-08 07:30:00	SPY	ETF	198.76	198.96	198.69	198.88	207886.0
2015-10-08 08:00:00	SPY	ETF	198.73	199.41	198.59	198.64	392160.0
2015-10-08 08:30:00	SPY	ETF	198.67	198.83	198.33	198.61	588086.0
2015-10-08 09:00:00	SPY	ETF	198.61	198.97	198.47	198.96	425618.0
2015-10-08 09:30:00	SPY	ETF	198.95	199.17	198.59	199.0	11845539.0
2015-10-08 10:00:00	SPY	ETF	198.99	199.29	198.69	198.77	6975196.0
2015-10-08 10:30:00	SPY	ETF	198.77	199.25	198.745	199.14	4948375.0
2015-10-08 11:00:00	SPY	ETF	199.14	199.27	198.68	199.15	7136253.0
2015-10-08 11:30:00	SPY	ETF	199.15	199.43	199.15	199.36	5335516.0
2015-10-08 12:00:00	SPY	ETF	199.37	199.65	199.15	199.22	6576036.0
2015-10-08 12:30:00	SPY	ETF	199.225	199.56	198.75	198.95	6094747.0
2015-10-08 13:00:00	SPY	ETF	198.9427	199.44	198.87	199.33	4517056.0
2015-10-08 13:30:00	SPY	ETF	199.34	199.6	199.33	199.55	4765871.0
2015-10-08 14:00:00	SPY	ETF	199.55	200.26	199.31	199.99	24830592.0
2015-10-08 14:30:00	SPY	ETF	199.985	200.94	199.91	200.81	13941669.0
2015-10-08 15:00:00	SPY	ETF	200.81	201.55	200.78	201.13	19745700.0
2015-10-08 15:30:00	SPY	ETF	201.13	201.29	200.77	201.22	24542466.0
2015-10-08 16:00:00	SPY	ETF	201.19	201.4	201.08	201.36	3412187.0
2015-10-08 16:30:00	SPY	ETF	201.36	201.39	201.12	201.26	3011719.0
2015-10-08 17:00:00	SPY	ETF	201.25	201.32	201.17	201.3	60122.0
2015-10-08 17:30:00	SPY	ETF	201.25	201.25	201.07	201.08	92427.0
2015-10-08 18:00:00	SPY	ETF	201.1	201.21	201.04	201.21	1116889.0
2015-10-08 18:30:00	SPY	ETF	201.13	201.19	201.12	201.16	9495.0
2015-10-08 19:00:00	SPY	ETF	201.2	201.3	201.19	201.25	33557.0
2015-10-08 19:30:00	SPY	ETF	201.26	201.26	201.14	201.19	79938.0
2015-10-08 04:30:00	QQQ	ETF	104.92	105.0	104.92	104.92	4300.0
2015-10-08 05:00:00	QQQ	ETF	104.97	105.11	104.97	105.11	3070.0
2015-10-08 05:30:00	QQQ	ETF	105.14	105.14	105.01	105.07	9200.0
2015-10-08 06:00:00	QQQ	ETF	105.08	105.34	105.08	105.3	1500.0
2015-10-08 06:30:00	QQQ	ETF	105.26	105.3	105.17	105.24	1798.0
2015-10-08 07:00:00	QQQ	ETF	105.27	105.32	105.25	105.27	4300.0
2015-10-08 07:30:00	QQQ	ETF	105.37	105.37	105.25	105.32	19800.0
2015-10-08 08:00:00	QQQ	ETF	105.33	105.63	105.2	105.2	35371.0
2015-10-08 08:30:00	QQQ	ETF	105.22	105.26	105.06	105.15	73453.0
2015-10-08 09:00:00	QQQ	ETF	105.11	105.24	105.1	105.23	43553.0
2015-10-08 09:30:00	QQQ	ETF	105.23	105.29	104.86	105.09	7143891.0
2015-10-08 10:00:00	QQQ	ETF	105.09	105.25	104.6801	104.77	3194644.0
2015-10-08 10:30:00	QQQ	ETF	104.75	104.99	104.71	104.87	1589341.0
2015-10-08 11:00:00	QQQ	ETF	104.87	104.94	104.38	104.59	2117619.0
2015-10-08 11:30:00	QQQ	ETF	104.6	104.82	104.59	104.77	1371335.0
2015-10-08 12:00:00	QQQ	ETF	104.77	104.97	104.45	104.51	1843550.0
2015-10-08 12:30:00	QQQ	ETF	104.5	104.78	104.21	104.35	1794771.0
2015-10-08 13:00:00	QQQ	ETF	104.36	104.77	104.33	104.7	1369557.0

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

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