PREVIEW / etf_30min / 2017-12-13

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-12-13.parquet
  size:    451 KB
  rows:    15,560

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-12-13 04:00:00	SPY	ETF	266.57	266.72	266.57	266.72	483.0
2017-12-13 05:30:00	SPY	ETF	266.73	266.73	266.73	266.73	101.0
2017-12-13 06:00:00	SPY	ETF	266.9	266.92	266.82	266.9	6004.0
2017-12-13 07:00:00	SPY	ETF	266.75	266.77	266.63	266.73	57495.0
2017-12-13 07:30:00	SPY	ETF	266.73	266.75	266.55	266.64	109423.0
2017-12-13 08:00:00	SPY	ETF	266.72	266.86	266.62	266.85	168870.0
2017-12-13 08:30:00	SPY	ETF	266.83	267.1	266.73	267.01	404127.0
2017-12-13 09:00:00	SPY	ETF	267.04	267.16	266.99	267.06	377383.0
2017-12-13 09:30:00	SPY	ETF	267.06	267.47	267.05	267.39	14544935.0
2017-12-13 10:00:00	SPY	ETF	267.3999	267.465	267.2	267.3656	5475816.0
2017-12-13 10:30:00	SPY	ETF	267.36	267.51	267.27	267.43	3227273.0
2017-12-13 11:00:00	SPY	ETF	267.44	267.52	267.35	267.43	4140041.0
2017-12-13 11:30:00	SPY	ETF	267.44	267.56	267.32	267.495	4988091.0
2017-12-13 12:00:00	SPY	ETF	267.49	267.495	267.05	267.24	3452392.0
2017-12-13 12:30:00	SPY	ETF	267.245	267.27	266.96	267.09	3551984.0
2017-12-13 13:00:00	SPY	ETF	267.08	267.2134	266.91	267.035	4469545.0
2017-12-13 13:30:00	SPY	ETF	267.04	267.119	266.79	266.97	3062490.0
2017-12-13 14:00:00	SPY	ETF	266.97	267.53	266.97	267.315	8739909.0
2017-12-13 14:30:00	SPY	ETF	267.325	267.54	267.29	267.48	4708201.0
2017-12-13 15:00:00	SPY	ETF	267.485	267.49	266.98	267.04	8104634.0
2017-12-13 15:30:00	SPY	ETF	267.04	267.25	266.65	266.73	13198167.0
2017-12-13 16:00:00	SPY	ETF	266.75	266.95	266.6205	266.92	16922116.0
2017-12-13 16:30:00	SPY	ETF	266.93	267.2	266.75	266.94	814829.0
2017-12-13 17:00:00	SPY	ETF	266.93	266.97	266.89	266.94	70247.0
2017-12-13 17:30:00	SPY	ETF	266.92	266.94	266.91	266.92	16925.0
2017-12-13 18:00:00	SPY	ETF	266.92	266.99	266.89	266.92	22855.0
2017-12-13 18:30:00	SPY	ETF	266.87	266.97	266.86	266.97	4756.0
2017-12-13 19:00:00	SPY	ETF	266.98	267.14	266.97	267.14	13999.0
2017-12-13 19:30:00	SPY	ETF	267.12	267.21	267.12	267.21	26983.0
2017-12-13 04:00:00	QQQ	ETF	155.83	155.84	155.8	155.83	5287.0
2017-12-13 05:00:00	QQQ	ETF	155.81	155.81	155.81	155.81	100.0
2017-12-13 05:30:00	QQQ	ETF	155.85	155.86	155.85	155.86	999.0
2017-12-13 06:00:00	QQQ	ETF	155.88	155.89	155.84	155.89	3903.0
2017-12-13 06:30:00	QQQ	ETF	155.8	155.8	155.8	155.8	4996.0
2017-12-13 07:00:00	QQQ	ETF	155.82	155.82	155.76	155.82	7290.0
2017-12-13 07:30:00	QQQ	ETF	155.83	155.83	155.65	155.67	5330.0
2017-12-13 08:00:00	QQQ	ETF	155.64	155.87	155.64	155.86	33698.0
2017-12-13 08:30:00	QQQ	ETF	155.84	156.25	155.81	156.16	84230.0
2017-12-13 09:00:00	QQQ	ETF	156.18	156.4	156.17	156.31	92108.0
2017-12-13 09:30:00	QQQ	ETF	156.28	156.49	156.22	156.33	2472657.0
2017-12-13 10:00:00	QQQ	ETF	156.33	156.37	156.03	156.15	1904997.0
2017-12-13 10:30:00	QQQ	ETF	156.15	156.37	156.08	156.37	1165702.0
2017-12-13 11:00:00	QQQ	ETF	156.365	156.47	156.27	156.275	639802.0
2017-12-13 11:30:00	QQQ	ETF	156.29	156.38	156.1301	156.1764	778565.0
2017-12-13 12:00:00	QQQ	ETF	156.17	156.17	155.88	156.09	1084072.0
2017-12-13 12:30:00	QQQ	ETF	156.1	156.11	155.77	156.0144	851798.0
2017-12-13 13:00:00	QQQ	ETF	156.01	156.046	155.89	155.95	498571.0
2017-12-13 13:30:00	QQQ	ETF	155.945	155.96	155.76	155.87	936674.0
2017-12-13 14:00:00	QQQ	ETF	155.87	156.37	155.87	156.2	2068430.0
2017-12-13 14:30:00	QQQ	ETF	156.2	156.4	156.13	156.345	990184.0

> showing 50 of 15,560 rows — these rows as CSV

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