PREVIEW / etf_30min / 2017-02-16

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-02-16.parquet
  size:    434 KB
  rows:    14,809

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
2017-02-16 04:00:00	SPY	ETF	235.0	235.0	234.88	234.9	5050.0
2017-02-16 04:30:00	SPY	ETF	234.97	234.97	234.87	234.89	2900.0
2017-02-16 05:00:00	SPY	ETF	234.85	234.9	234.81	234.81	7675.0
2017-02-16 05:30:00	SPY	ETF	234.81	234.83	234.78	234.83	4000.0
2017-02-16 06:00:00	SPY	ETF	234.9	234.92	234.83	234.83	17691.0
2017-02-16 06:30:00	SPY	ETF	234.88	234.88	234.82	234.86	4122.0
2017-02-16 07:00:00	SPY	ETF	234.88	234.91	234.83	234.84	12950.0
2017-02-16 07:30:00	SPY	ETF	234.87	234.88	234.75	234.78	31325.0
2017-02-16 08:00:00	SPY	ETF	234.78	234.89	234.63	234.67	355992.0
2017-02-16 08:30:00	SPY	ETF	234.65	234.89	234.64	234.86	243591.0
2017-02-16 09:00:00	SPY	ETF	234.87	234.98	234.85	234.95	636556.0
2017-02-16 09:30:00	SPY	ETF	234.96	235.155	234.51	234.67	9719055.0
2017-02-16 10:00:00	SPY	ETF	234.66	234.775	234.47	234.61	6661305.0
2017-02-16 10:30:00	SPY	ETF	234.61	234.95	233.97	234.31	7981200.0
2017-02-16 11:00:00	SPY	ETF	234.31	234.39	233.85	234.35	7856511.0
2017-02-16 11:30:00	SPY	ETF	234.345	234.53	234.21	234.5202	4209366.0
2017-02-16 12:00:00	SPY	ETF	234.5201	234.57	234.25	234.45	3450676.0
2017-02-16 12:30:00	SPY	ETF	234.445	234.7	234.38	234.44	4553786.0
2017-02-16 13:00:00	SPY	ETF	234.445	234.46	234.2	234.33	3664381.0
2017-02-16 13:30:00	SPY	ETF	234.325	234.4	234.17	234.345	3880695.0
2017-02-16 14:00:00	SPY	ETF	234.345	234.45	234.09	234.25	4789370.0
2017-02-16 14:30:00	SPY	ETF	234.24	234.42	234.12	234.375	4074353.0
2017-02-16 15:00:00	SPY	ETF	234.375	234.55	234.34	234.49	4155824.0
2017-02-16 15:30:00	SPY	ETF	234.485	234.75	234.47	234.73	11076570.0
2017-02-16 16:00:00	SPY	ETF	234.74	234.89	234.7	234.74	4016554.0
2017-02-16 16:30:00	SPY	ETF	234.75	234.83	234.7	234.75	316556.0
2017-02-16 17:00:00	SPY	ETF	234.73	234.77	234.7052	234.76	2206155.0
2017-02-16 17:30:00	SPY	ETF	234.72	234.72	234.7	234.7	13986.0
2017-02-16 18:00:00	SPY	ETF	234.69	234.69	234.62	234.64	34800.0
2017-02-16 18:30:00	SPY	ETF	234.65	234.65	234.57	234.57	25698.0
2017-02-16 19:00:00	SPY	ETF	234.58	234.58	234.51	234.54	56224.0
2017-02-16 19:30:00	SPY	ETF	234.52	234.67	234.51	234.65	26963.0
2017-02-16 04:00:00	QQQ	ETF	129.38	129.38	129.38	129.38	1000.0
2017-02-16 04:30:00	QQQ	ETF	129.37	129.38	129.37	129.38	700.0
2017-02-16 05:00:00	QQQ	ETF	129.4	129.4	129.4	129.4	200.0
2017-02-16 05:30:00	QQQ	ETF	129.39	129.39	129.39	129.39	263.0
2017-02-16 06:00:00	QQQ	ETF	129.42	129.43	129.42	129.43	200.0
2017-02-16 06:30:00	QQQ	ETF	129.4	129.4	129.36	129.38	5150.0
2017-02-16 07:00:00	QQQ	ETF	129.39	129.45	129.39	129.44	12849.0
2017-02-16 07:30:00	QQQ	ETF	129.41	129.43	129.34	129.37	26509.0
2017-02-16 08:00:00	QQQ	ETF	129.36	129.38	129.31	129.32	29025.0
2017-02-16 08:30:00	QQQ	ETF	129.33	129.4	129.32	129.38	49378.0
2017-02-16 09:00:00	QQQ	ETF	129.38	129.41	129.33	129.33	102997.0
2017-02-16 09:30:00	QQQ	ETF	129.37	129.63	129.2	129.31	1900103.0
2017-02-16 10:00:00	QQQ	ETF	129.305	129.47	129.18	129.4199	1159932.0
2017-02-16 10:30:00	QQQ	ETF	129.4165	129.54	128.95	129.14	1642211.0
2017-02-16 11:00:00	QQQ	ETF	129.14	129.2	128.92	129.16	982840.0
2017-02-16 11:30:00	QQQ	ETF	129.165	129.17	129.0	129.145	1616865.0
2017-02-16 12:00:00	QQQ	ETF	129.145	129.2	129.015	129.18	682066.0
2017-02-16 12:30:00	QQQ	ETF	129.18	129.23	129.075	129.075	505110.0

> showing 50 of 14,809 rows — these rows as CSV

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