PREVIEW / etf_30min / 2018-05-15

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-05-15.parquet
  size:    469 KB
  rows:    16,262

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
2018-05-15 04:00:00	SPY	ETF	272.63	272.63	272.28	272.31	4830.0
2018-05-15 04:30:00	SPY	ETF	272.37	272.37	272.28	272.3	6390.0
2018-05-15 05:00:00	SPY	ETF	272.44	272.59	272.44	272.59	700.0
2018-05-15 05:30:00	SPY	ETF	272.63	272.75	272.6	272.74	2100.0
2018-05-15 06:00:00	SPY	ETF	272.66	272.8	272.66	272.8	6700.0
2018-05-15 06:30:00	SPY	ETF	272.75	272.76	272.67	272.67	18980.0
2018-05-15 07:00:00	SPY	ETF	272.64	272.74	272.28	272.33	82410.0
2018-05-15 07:30:00	SPY	ETF	272.26	272.43	272.18	272.31	68591.0
2018-05-15 08:00:00	SPY	ETF	272.25	272.72	272.12	272.37	240220.0
2018-05-15 08:30:00	SPY	ETF	272.38	272.98	271.18	271.44	1184258.0
2018-05-15 09:00:00	SPY	ETF	271.45	271.67	271.3	271.55	656031.0
2018-05-15 09:30:00	SPY	ETF	271.59	271.61	270.29	270.37	10876447.0
2018-05-15 10:00:00	SPY	ETF	270.35	271.05	270.3	270.81	5435500.0
2018-05-15 10:30:00	SPY	ETF	270.81	271.52	270.72	270.95	4073882.0
2018-05-15 11:00:00	SPY	ETF	270.94	271.32	270.75	270.91	2878586.0
2018-05-15 11:30:00	SPY	ETF	270.92	271.25	270.6	270.65	2971383.0
2018-05-15 12:00:00	SPY	ETF	270.659	270.74	270.28	270.6	4611789.0
2018-05-15 12:30:00	SPY	ETF	270.59	271.39	270.52	270.99	3216321.0
2018-05-15 13:00:00	SPY	ETF	270.99	271.06	270.5	270.59	3139250.0
2018-05-15 13:30:00	SPY	ETF	270.585	270.78	270.08	270.11	3510509.0
2018-05-15 14:00:00	SPY	ETF	270.11	270.75	270.07	270.61	5369233.0
2018-05-15 14:30:00	SPY	ETF	270.61	271.16	270.35	270.51	4326350.0
2018-05-15 15:00:00	SPY	ETF	270.52	270.67	270.03	270.23	6901437.0
2018-05-15 15:30:00	SPY	ETF	270.22	271.1	270.14	271.03	14429165.0
2018-05-15 16:00:00	SPY	ETF	271.04	271.2	270.7031	270.96	8391421.0
2018-05-15 16:30:00	SPY	ETF	270.96	271.0	270.87	270.93	144624.0
2018-05-15 17:00:00	SPY	ETF	270.99	271.02	270.92	270.98	59064.0
2018-05-15 17:30:00	SPY	ETF	270.99	271.02	270.94	271.01	7328.0
2018-05-15 18:00:00	SPY	ETF	271.03	271.09	270.75	270.82	63302.0
2018-05-15 18:30:00	SPY	ETF	270.8	270.8	270.6	270.66	27780.0
2018-05-15 19:00:00	SPY	ETF	270.68	270.7	270.42	270.48	26862.0
2018-05-15 19:30:00	SPY	ETF	270.6	270.7	270.5	270.64	34083.0
2018-05-15 04:00:00	QQQ	ETF	169.47	169.47	169.4	169.4	1780.0
2018-05-15 04:30:00	QQQ	ETF	169.35	169.41	169.35	169.41	1300.0
2018-05-15 05:00:00	QQQ	ETF	169.38	169.53	169.38	169.53	1289.0
2018-05-15 05:30:00	QQQ	ETF	169.55	169.59	169.55	169.59	13300.0
2018-05-15 06:00:00	QQQ	ETF	169.55	169.63	169.55	169.62	5100.0
2018-05-15 06:30:00	QQQ	ETF	169.62	169.62	169.51	169.51	4979.0
2018-05-15 07:00:00	QQQ	ETF	169.51	169.57	169.23	169.25	22519.0
2018-05-15 07:30:00	QQQ	ETF	169.22	169.27	169.07	169.15	36681.0
2018-05-15 08:00:00	QQQ	ETF	169.38	169.5001	169.08	169.23	80993.0
2018-05-15 08:30:00	QQQ	ETF	169.23	169.75	168.19	168.33	764817.0
2018-05-15 09:00:00	QQQ	ETF	168.3	168.5	168.15	168.41	529264.0
2018-05-15 09:30:00	QQQ	ETF	168.4	168.5	167.1	167.19	7076968.0
2018-05-15 10:00:00	QQQ	ETF	167.18	167.9	167.1	167.76	3736042.0
2018-05-15 10:30:00	QQQ	ETF	167.75	168.29	167.48	167.55	3725749.0
2018-05-15 11:00:00	QQQ	ETF	167.55	167.86	167.275	167.45	1815388.0
2018-05-15 11:30:00	QQQ	ETF	167.46	167.84	167.405	167.45	1842870.0
2018-05-15 12:00:00	QQQ	ETF	167.46	167.54	167.16	167.45	1291504.0
2018-05-15 12:30:00	QQQ	ETF	167.44	167.93	167.39	167.64	1567717.0

> showing 50 of 16,262 rows — these rows as CSV

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