PREVIEW / etf_30min / 2018-05-16

all etf 30-min files

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

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-16 04:00:00	SPY	ETF	271.32	271.33	271.2	271.28	4909.0
2018-05-16 04:30:00	SPY	ETF	271.21	271.21	271.01	271.01	4119.0
2018-05-16 05:00:00	SPY	ETF	271.07	271.07	270.62	270.67	15600.0
2018-05-16 05:30:00	SPY	ETF	270.64	270.87	270.64	270.84	12725.0
2018-05-16 06:00:00	SPY	ETF	270.88	270.95	270.83	270.95	14000.0
2018-05-16 06:30:00	SPY	ETF	270.77	271.12	270.72	271.12	22447.0
2018-05-16 07:00:00	SPY	ETF	271.11	271.17	271.02	271.02	161278.0
2018-05-16 07:30:00	SPY	ETF	271.01	271.06	270.77	270.85	147951.0
2018-05-16 08:00:00	SPY	ETF	270.83	271.16	270.7	270.88	2445022.0
2018-05-16 08:30:00	SPY	ETF	270.86	270.94	270.47	270.53	220637.0
2018-05-16 09:00:00	SPY	ETF	270.55	271.17	270.47	271.1	306531.0
2018-05-16 09:30:00	SPY	ETF	271.14	271.95	271.11	271.81	5389509.0
2018-05-16 10:00:00	SPY	ETF	271.83	271.88	271.3	271.535	3440039.0
2018-05-16 10:30:00	SPY	ETF	271.55	271.99	271.52	271.6825	2146443.0
2018-05-16 11:00:00	SPY	ETF	271.68	271.74	271.2	271.329	2413696.0
2018-05-16 11:30:00	SPY	ETF	271.33	271.88	271.32	271.86	1732897.0
2018-05-16 12:00:00	SPY	ETF	271.88	272.42	271.86	272.37	3887514.0
2018-05-16 12:30:00	SPY	ETF	272.375	272.71	272.32	272.425	2188985.0
2018-05-16 13:00:00	SPY	ETF	272.43	272.579	272.2	272.255	1618488.0
2018-05-16 13:30:00	SPY	ETF	272.25	272.53	272.24	272.485	2388142.0
2018-05-16 14:00:00	SPY	ETF	272.48	272.62	272.3634	272.49	1334650.0
2018-05-16 14:30:00	SPY	ETF	272.48	272.76	272.38	272.6414	1466867.0
2018-05-16 15:00:00	SPY	ETF	272.65	272.65	272.06	272.18	3714514.0
2018-05-16 15:30:00	SPY	ETF	272.17	272.22	271.69	272.21	8438958.0
2018-05-16 16:00:00	SPY	ETF	272.21	272.27	272.11	272.21	8079654.0
2018-05-16 16:30:00	SPY	ETF	272.2	272.24	272.09	272.1	221411.0
2018-05-16 17:00:00	SPY	ETF	272.12	272.24	272.06	272.23	312340.0
2018-05-16 17:30:00	SPY	ETF	272.22	272.24	272.14	272.17	513068.0
2018-05-16 18:00:00	SPY	ETF	272.17	272.25	272.13	272.14	84599.0
2018-05-16 18:30:00	SPY	ETF	272.2	272.4	272.16	272.33	20122.0
2018-05-16 19:00:00	SPY	ETF	272.32	272.32	272.23	272.24	7312.0
2018-05-16 19:30:00	SPY	ETF	272.25	272.44	272.25	272.44	9464.0
2018-05-16 04:00:00	QQQ	ETF	168.02	168.13	168.02	168.03	3586.0
2018-05-16 04:30:00	QQQ	ETF	168.02	168.05	167.93	167.93	1340.0
2018-05-16 05:00:00	QQQ	ETF	167.99	167.99	167.69	167.7	5900.0
2018-05-16 05:30:00	QQQ	ETF	167.72	167.92	167.72	167.92	8500.0
2018-05-16 06:00:00	QQQ	ETF	167.92	167.93	167.84	167.87	3132.0
2018-05-16 06:30:00	QQQ	ETF	167.83	168.13	167.83	168.08	6238.0
2018-05-16 07:00:00	QQQ	ETF	168.1	168.12	168.02	168.02	158565.0
2018-05-16 07:30:00	QQQ	ETF	168.01	168.01	167.81	167.9	46521.0
2018-05-16 08:00:00	QQQ	ETF	168.09	168.09	167.75	167.86	51926.0
2018-05-16 08:30:00	QQQ	ETF	167.9	167.96	167.7	167.77	213512.0
2018-05-16 09:00:00	QQQ	ETF	167.75	168.15	167.71	168.08	218519.0
2018-05-16 09:30:00	QQQ	ETF	168.08	168.66	168.01	168.61	2137889.0
2018-05-16 10:00:00	QQQ	ETF	168.61	168.73	168.33	168.57	2351931.0
2018-05-16 10:30:00	QQQ	ETF	168.58	168.9693	168.51	168.66	1152248.0
2018-05-16 11:00:00	QQQ	ETF	168.65	168.65	168.24	168.34	1798602.0
2018-05-16 11:30:00	QQQ	ETF	168.33	168.77	168.3261	168.77	796026.0
2018-05-16 12:00:00	QQQ	ETF	168.78	169.1599	168.775	169.1	978309.0
2018-05-16 12:30:00	QQQ	ETF	169.1	169.37	169.0817	169.17	1073851.0

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

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