PREVIEW / etf_30min / 2017-01-27

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-01-27.parquet
  size:    423 KB
  rows:    14,388

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-01-27 04:00:00	SPY	ETF	229.55	229.55	229.42	229.46	4809.0
2017-01-27 04:30:00	SPY	ETF	229.46	229.46	229.28	229.28	806.0
2017-01-27 05:00:00	SPY	ETF	229.27	229.29	229.18	229.28	2259.0
2017-01-27 05:30:00	SPY	ETF	229.33	229.38	229.33	229.34	4803.0
2017-01-27 06:00:00	SPY	ETF	229.38	229.46	229.34	229.41	4013.0
2017-01-27 06:30:00	SPY	ETF	229.44	229.44	229.32	229.36	1202.0
2017-01-27 07:00:00	SPY	ETF	229.34	229.46	229.27	229.39	48618.0
2017-01-27 07:30:00	SPY	ETF	229.39	229.55	229.39	229.52	46128.0
2017-01-27 08:00:00	SPY	ETF	229.52	229.58	229.31	229.55	75797.0
2017-01-27 08:30:00	SPY	ETF	229.54	229.55	229.39	229.48	104828.0
2017-01-27 09:00:00	SPY	ETF	229.45	229.52	229.35	229.42	500734.0
2017-01-27 09:30:00	SPY	ETF	229.42	229.59	228.9	229.0347	5021328.0
2017-01-27 10:00:00	SPY	ETF	229.03	229.13	228.88	228.95	3834872.0
2017-01-27 10:30:00	SPY	ETF	228.95	229.12	228.79	228.84	2642145.0
2017-01-27 11:00:00	SPY	ETF	228.849	229.1	228.835	229.01	4474374.0
2017-01-27 11:30:00	SPY	ETF	229.01	229.09	228.895	229.07	2945329.0
2017-01-27 12:00:00	SPY	ETF	229.07	229.17	229.02	229.05	2171569.0
2017-01-27 12:30:00	SPY	ETF	229.045	229.09	228.89	229.0	2231839.0
2017-01-27 13:00:00	SPY	ETF	229.0098	229.02	228.89	228.99	1840990.0
2017-01-27 13:30:00	SPY	ETF	228.99	229.04	228.91	228.91	2680390.0
2017-01-27 14:00:00	SPY	ETF	228.91	228.98	228.87	228.91	2992245.0
2017-01-27 14:30:00	SPY	ETF	228.915	229.02	228.91	228.96	1795114.0
2017-01-27 15:00:00	SPY	ETF	228.96	228.97	228.76	228.77	2674854.0
2017-01-27 15:30:00	SPY	ETF	228.77	229.06	228.77	228.99	8877244.0
2017-01-27 16:00:00	SPY	ETF	229.0	229.0807	228.95	228.97	10484586.0
2017-01-27 16:30:00	SPY	ETF	228.97	229.02	228.94	229.01	2790552.0
2017-01-27 17:00:00	SPY	ETF	229.01	229.01	228.92	229.0	108959.0
2017-01-27 17:30:00	SPY	ETF	229.0	229.02	228.97	228.97	21275.0
2017-01-27 18:00:00	SPY	ETF	228.97	228.97	228.93	228.95	28208.0
2017-01-27 18:30:00	SPY	ETF	228.95	228.97	228.95	228.95	3458.0
2017-01-27 19:00:00	SPY	ETF	228.97	228.97	228.95	228.96	5400.0
2017-01-27 19:30:00	SPY	ETF	228.97	229.0	228.96	229.0	9036.0
2017-01-27 05:30:00	QQQ	ETF	125.45	125.45	125.45	125.45	100.0
2017-01-27 06:00:00	QQQ	ETF	125.49	125.49	125.47	125.47	500.0
2017-01-27 06:30:00	QQQ	ETF	125.52	125.52	125.51	125.51	5100.0
2017-01-27 07:00:00	QQQ	ETF	125.54	125.57	125.54	125.57	1615.0
2017-01-27 07:30:00	QQQ	ETF	125.58	125.64	125.58	125.64	3100.0
2017-01-27 08:00:00	QQQ	ETF	125.62	125.68	125.47	125.67	79336.0
2017-01-27 08:30:00	QQQ	ETF	125.66	125.7	125.61	125.7	25695.0
2017-01-27 09:00:00	QQQ	ETF	125.68	125.82	125.68	125.81	216010.0
2017-01-27 09:30:00	QQQ	ETF	125.805	125.9211	125.4507	125.55	3394436.0
2017-01-27 10:00:00	QQQ	ETF	125.55	125.62	125.39	125.57	1492378.0
2017-01-27 10:30:00	QQQ	ETF	125.5727	125.731	125.57	125.66	728223.0
2017-01-27 11:00:00	QQQ	ETF	125.66	125.78	125.58	125.74	636174.0
2017-01-27 11:30:00	QQQ	ETF	125.74	125.76	125.64	125.7	479245.0
2017-01-27 12:00:00	QQQ	ETF	125.7	125.8	125.69	125.775	407321.0
2017-01-27 12:30:00	QQQ	ETF	125.77	125.805	125.69	125.77	513993.0
2017-01-27 13:00:00	QQQ	ETF	125.78	125.79	125.7	125.72	346226.0
2017-01-27 13:30:00	QQQ	ETF	125.727	125.765	125.674	125.68	494739.0
2017-01-27 14:00:00	QQQ	ETF	125.69	125.73	125.65	125.72	524021.0

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

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