PREVIEW / etf_30min / 2015-10-13

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-10-13.parquet
  size:    377 KB
  rows:    12,660

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-13 04:00:00	SPY	ETF	200.83	201.14	200.55	200.55	31565.0
2015-10-13 04:30:00	SPY	ETF	200.5	200.81	200.36	200.81	27543.0
2015-10-13 05:00:00	SPY	ETF	200.73	200.73	200.45	200.56	11708.0
2015-10-13 05:30:00	SPY	ETF	200.7	200.74	200.55	200.55	7268.0
2015-10-13 06:00:00	SPY	ETF	200.57	200.9	200.57	200.86	35218.0
2015-10-13 06:30:00	SPY	ETF	200.89	201.06	200.84	200.99	31519.0
2015-10-13 07:00:00	SPY	ETF	200.98	201.11	200.92	201.0	107746.0
2015-10-13 07:30:00	SPY	ETF	201.0	201.08	200.72	200.77	96828.0
2015-10-13 08:00:00	SPY	ETF	200.79	201.11	200.7	200.7	355636.0
2015-10-13 08:30:00	SPY	ETF	200.69	200.78	200.43	200.55	917037.0
2015-10-13 09:00:00	SPY	ETF	200.58	200.69	200.47	200.63	413327.0
2015-10-13 09:30:00	SPY	ETF	200.65	201.27	200.5	201.17	10696128.0
2015-10-13 10:00:00	SPY	ETF	201.18	201.65	201.11	201.6328	7103158.0
2015-10-13 10:30:00	SPY	ETF	201.63	201.98	201.51	201.94	5375953.0
2015-10-13 11:00:00	SPY	ETF	201.93	202.16	201.68	201.69	5473938.0
2015-10-13 11:30:00	SPY	ETF	201.69	201.83	201.47	201.58	4533114.0
2015-10-13 12:00:00	SPY	ETF	201.58	201.71	201.46	201.537	2508406.0
2015-10-13 12:30:00	SPY	ETF	201.54	201.69	201.01	201.01	3604024.0
2015-10-13 13:00:00	SPY	ETF	201.01	201.14	200.84	201.09	4147047.0
2015-10-13 13:30:00	SPY	ETF	201.1	201.12	200.74	200.8	4212157.0
2015-10-13 14:00:00	SPY	ETF	200.795	201.02	200.64	200.725	4014520.0
2015-10-13 14:30:00	SPY	ETF	200.725	201.06	200.54	201.04	4511040.0
2015-10-13 15:00:00	SPY	ETF	201.045	201.05	200.22	200.45	6454657.0
2015-10-13 15:30:00	SPY	ETF	200.45	200.58	200.05	200.22	12381415.0
2015-10-13 16:00:00	SPY	ETF	200.21	200.43	199.9	200.11	5754158.0
2015-10-13 16:30:00	SPY	ETF	200.1	200.25	199.86	199.96	1230798.0
2015-10-13 17:00:00	SPY	ETF	200.03	200.06	199.51	199.77	222165.0
2015-10-13 17:30:00	SPY	ETF	199.75	199.85	199.73	199.83	44235.0
2015-10-13 18:00:00	SPY	ETF	199.84	199.88	199.76	199.84	57710.0
2015-10-13 18:30:00	SPY	ETF	199.83	199.91	199.78	199.91	11761.0
2015-10-13 19:00:00	SPY	ETF	199.91	200.01	199.88	199.95	21007.0
2015-10-13 19:30:00	SPY	ETF	199.97	199.99	199.9	199.99	38148.0
2015-10-13 04:00:00	QQQ	ETF	106.45	106.45	106.14	106.14	9210.0
2015-10-13 04:30:00	QQQ	ETF	106.11	106.21	106.05	106.21	8838.0
2015-10-13 05:00:00	QQQ	ETF	106.09	106.09	106.07	106.07	6850.0
2015-10-13 06:00:00	QQQ	ETF	106.13	106.29	106.13	106.29	2850.0
2015-10-13 06:30:00	QQQ	ETF	106.29	106.33	106.26	106.33	3600.0
2015-10-13 07:00:00	QQQ	ETF	106.33	106.4	106.29	106.33	8172.0
2015-10-13 07:30:00	QQQ	ETF	106.35	106.36	106.21	106.21	11300.0
2015-10-13 08:00:00	QQQ	ETF	106.23	106.4	106.15	106.15	18410.0
2015-10-13 08:30:00	QQQ	ETF	106.14	106.23	106.07	106.14	78093.0
2015-10-13 09:00:00	QQQ	ETF	106.14	106.24	106.1	106.17	142882.0
2015-10-13 09:30:00	QQQ	ETF	106.18	106.64	106.08	106.57	2955579.0
2015-10-13 10:00:00	QQQ	ETF	106.56	106.98	106.49	106.95	2193808.0
2015-10-13 10:30:00	QQQ	ETF	106.95	107.19	106.84	107.16	2185663.0
2015-10-13 11:00:00	QQQ	ETF	107.16	107.26	106.9	106.94	1343439.0
2015-10-13 11:30:00	QQQ	ETF	106.93	106.99	106.78	106.86	1477617.0
2015-10-13 12:00:00	QQQ	ETF	106.87	106.96	106.811	106.86	772153.0
2015-10-13 12:30:00	QQQ	ETF	106.87	106.99	106.57	106.57	1406228.0
2015-10-13 13:00:00	QQQ	ETF	106.57	106.67	106.47	106.63	1271101.0

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

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