PREVIEW / etf_30min / 2018-05-23

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-05-23.parquet
  size:    464 KB
  rows:    16,051

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-23 04:00:00	SPY	ETF	271.18	271.27	270.7	270.86	24451.0
2018-05-23 04:30:00	SPY	ETF	270.76	271.09	270.76	270.87	7230.0
2018-05-23 05:00:00	SPY	ETF	270.86	271.07	270.71	270.8	19063.0
2018-05-23 05:30:00	SPY	ETF	270.82	270.9	270.6	270.72	146313.0
2018-05-23 06:00:00	SPY	ETF	270.78	270.98	270.7	270.95	54806.0
2018-05-23 06:30:00	SPY	ETF	270.95	271.1	270.95	271.02	32093.0
2018-05-23 07:00:00	SPY	ETF	271.04	271.12	270.9	271.09	185672.0
2018-05-23 07:30:00	SPY	ETF	271.08	271.11	270.75	270.96	77189.0
2018-05-23 08:00:00	SPY	ETF	270.95	272.18	270.76	271.01	286343.0
2018-05-23 08:30:00	SPY	ETF	271.02	271.2	270.98	271.07	165212.0
2018-05-23 09:00:00	SPY	ETF	271.07	271.21	270.86	271.15	484248.0
2018-05-23 09:30:00	SPY	ETF	271.17	271.76	271.11	271.597	6215734.0
2018-05-23 10:00:00	SPY	ETF	271.61	272.22	271.43	271.91	3427617.0
2018-05-23 10:30:00	SPY	ETF	271.91	271.9101	270.99	271.24	4595936.0
2018-05-23 11:00:00	SPY	ETF	271.23	271.805	271.18	271.62	3487608.0
2018-05-23 11:30:00	SPY	ETF	271.61	272.1	271.436	271.449	2817720.0
2018-05-23 12:00:00	SPY	ETF	271.45	271.87	271.1801	271.28	2512259.0
2018-05-23 12:30:00	SPY	ETF	271.28	271.96	271.25	271.88	1979487.0
2018-05-23 13:00:00	SPY	ETF	271.87	271.9	271.39	271.68	1569285.0
2018-05-23 13:30:00	SPY	ETF	271.68	271.81	271.54	271.69	1622265.0
2018-05-23 14:00:00	SPY	ETF	271.69	272.88	271.61	272.48	7011697.0
2018-05-23 14:30:00	SPY	ETF	272.48	272.8	272.25	272.79	2740144.0
2018-05-23 15:00:00	SPY	ETF	272.79	273.08	272.69	272.96	3863038.0
2018-05-23 15:30:00	SPY	ETF	272.965	273.39	272.66	273.38	9874657.0
2018-05-23 16:00:00	SPY	ETF	273.37	273.43	273.12	273.13	6451561.0
2018-05-23 16:30:00	SPY	ETF	273.13	273.36	271.25	273.13	2989334.0
2018-05-23 17:00:00	SPY	ETF	273.12	273.15	273.03	273.05	163502.0
2018-05-23 17:30:00	SPY	ETF	273.08	273.1	273.04	273.06	22973.0
2018-05-23 18:00:00	SPY	ETF	273.08	273.2	273.08	273.16	28939.0
2018-05-23 18:30:00	SPY	ETF	273.15	273.19	273.06	273.11	6360.0
2018-05-23 19:00:00	SPY	ETF	273.17	273.17	273.07	273.11	4923.0
2018-05-23 19:30:00	SPY	ETF	273.08	273.11	273.02	273.05	26276.0
2018-05-23 04:00:00	QQQ	ETF	167.07	167.5	166.6	166.6	17153.0
2018-05-23 04:30:00	QQQ	ETF	166.62	166.8	166.58	166.69	8848.0
2018-05-23 05:00:00	QQQ	ETF	166.69	166.8	166.56	166.64	14053.0
2018-05-23 05:30:00	QQQ	ETF	166.64	166.7	166.49	166.55	19096.0
2018-05-23 06:00:00	QQQ	ETF	166.61	166.68	166.51	166.68	15040.0
2018-05-23 06:30:00	QQQ	ETF	166.7	166.82	166.67	166.74	7552.0
2018-05-23 07:00:00	QQQ	ETF	166.74	166.88	166.67	166.8	59748.0
2018-05-23 07:30:00	QQQ	ETF	166.8	166.82	166.62	166.72	38560.0
2018-05-23 08:00:00	QQQ	ETF	166.72	166.9	166.54	166.76	244462.0
2018-05-23 08:30:00	QQQ	ETF	166.76	166.88	166.71	166.79	168108.0
2018-05-23 09:00:00	QQQ	ETF	166.77	166.89	166.64	166.89	232445.0
2018-05-23 09:30:00	QQQ	ETF	166.9	167.665	166.88	167.47	2870933.0
2018-05-23 10:00:00	QQQ	ETF	167.47	168.075	167.34	167.78	2208867.0
2018-05-23 10:30:00	QQQ	ETF	167.77	167.81	167.155	167.38	1780998.0
2018-05-23 11:00:00	QQQ	ETF	167.37	167.84	167.34	167.72	1297159.0
2018-05-23 11:30:00	QQQ	ETF	167.73	168.2801	167.661	167.86	1453017.0
2018-05-23 12:00:00	QQQ	ETF	167.8733	168.16	167.7408	167.7801	960799.0
2018-05-23 12:30:00	QQQ	ETF	167.78	168.459	167.78	168.35	1165918.0

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

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