PREVIEW / etf_30min / 2017-11-22

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-11-22.parquet
  size:    437 KB
  rows:    15,247

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-11-22 04:00:00	SPY	ETF	259.86	259.88	259.86	259.88	1100.0
2017-11-22 04:30:00	SPY	ETF	259.9	259.92	259.9	259.92	600.0
2017-11-22 05:00:00	SPY	ETF	259.92	259.95	259.92	259.95	5400.0
2017-11-22 06:00:00	SPY	ETF	259.92	259.93	259.9	259.93	800.0
2017-11-22 06:30:00	SPY	ETF	259.88	259.95	259.88	259.93	2757.0
2017-11-22 07:00:00	SPY	ETF	259.97	260.13	259.97	260.13	102193.0
2017-11-22 07:30:00	SPY	ETF	260.08	260.19	260.07	260.19	85990.0
2017-11-22 08:00:00	SPY	ETF	259.99	260.18	259.99	260.07	203083.0
2017-11-22 08:30:00	SPY	ETF	260.07	260.07	259.93	259.99	293962.0
2017-11-22 09:00:00	SPY	ETF	259.99	260.09	259.95	260.05	230700.0
2017-11-22 09:30:00	SPY	ETF	260.0	260.15	259.9	259.98	3881820.0
2017-11-22 10:00:00	SPY	ETF	259.98	260.04	259.79	259.82	4661599.0
2017-11-22 10:30:00	SPY	ETF	259.82	259.96	259.68	259.94	2721387.0
2017-11-22 11:00:00	SPY	ETF	259.95	260.0	259.68	259.76	2652856.0
2017-11-22 11:30:00	SPY	ETF	259.75	259.8	259.67	259.76	1693845.0
2017-11-22 12:00:00	SPY	ETF	259.77	259.8	259.6	259.7	1175613.0
2017-11-22 12:30:00	SPY	ETF	259.7	259.79	259.62	259.775	1607381.0
2017-11-22 13:00:00	SPY	ETF	259.77	259.78	259.57	259.75	2149450.0
2017-11-22 13:30:00	SPY	ETF	259.76	259.82	259.71	259.8	2988127.0
2017-11-22 14:00:00	SPY	ETF	259.805	259.96	259.79	259.825	2156771.0
2017-11-22 14:30:00	SPY	ETF	259.83	259.97	259.81	259.88	1970891.0
2017-11-22 15:00:00	SPY	ETF	259.87	259.93	259.79	259.919	1744109.0
2017-11-22 15:30:00	SPY	ETF	259.92	259.97	259.74	259.77	6040385.0
2017-11-22 16:00:00	SPY	ETF	259.78	259.79	259.61	259.76	7600553.0
2017-11-22 16:30:00	SPY	ETF	259.62	260.07	259.51	259.54	165150.0
2017-11-22 17:00:00	SPY	ETF	259.55	259.61	259.54	259.6	116178.0
2017-11-22 17:30:00	SPY	ETF	259.59	259.6	259.56	259.59	18929.0
2017-11-22 18:00:00	SPY	ETF	259.58	259.64	259.54	259.58	86194.0
2017-11-22 18:30:00	SPY	ETF	259.59	259.66	259.59	259.65	12804.0
2017-11-22 19:00:00	SPY	ETF	259.64	259.64	259.58	259.58	13439.0
2017-11-22 19:30:00	SPY	ETF	259.62	259.7692	259.59	259.66	215571.0
2017-11-22 04:00:00	QQQ	ETF	155.47	155.47	155.41	155.42	11000.0
2017-11-22 04:30:00	QQQ	ETF	155.4	155.4	155.4	155.4	100.0
2017-11-22 05:00:00	QQQ	ETF	155.48	155.49	155.48	155.49	2500.0
2017-11-22 05:30:00	QQQ	ETF	155.4	155.41	155.4	155.41	2497.0
2017-11-22 06:00:00	QQQ	ETF	155.43	155.43	155.38	155.38	6164.0
2017-11-22 07:00:00	QQQ	ETF	155.59	155.61	155.59	155.6	19300.0
2017-11-22 07:30:00	QQQ	ETF	155.57	155.75	155.57	155.75	6792.0
2017-11-22 08:00:00	QQQ	ETF	155.71	155.74	155.65	155.65	25648.0
2017-11-22 08:30:00	QQQ	ETF	155.64	155.66	155.54	155.59	33828.0
2017-11-22 09:00:00	QQQ	ETF	155.61	155.7	155.58	155.65	24861.0
2017-11-22 09:30:00	QQQ	ETF	155.63	155.77	155.341	155.49	1872177.0
2017-11-22 10:00:00	QQQ	ETF	155.495	155.57	155.37	155.48	1803466.0
2017-11-22 10:30:00	QQQ	ETF	155.48	155.65	155.43	155.58	995271.0
2017-11-22 11:00:00	QQQ	ETF	155.58	155.69	155.44	155.5	1223938.0
2017-11-22 11:30:00	QQQ	ETF	155.49	155.61	155.41	155.57	1173701.0
2017-11-22 12:00:00	QQQ	ETF	155.57	155.63	155.51	155.605	388982.0
2017-11-22 12:30:00	QQQ	ETF	155.6	155.64	155.52	155.6336	244644.0
2017-11-22 13:00:00	QQQ	ETF	155.6292	155.646	155.51	155.603	437519.0
2017-11-22 13:30:00	QQQ	ETF	155.6	155.63	155.5701	155.62	221120.0

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

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