PREVIEW / etf_30min / 2018-04-10

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-04-10.parquet
  size:    465 KB
  rows:    16,014

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-04-10 04:00:00	SPY	ETF	263.72	264.5	263.6	264.5	35846.0
2018-04-10 04:30:00	SPY	ETF	264.26	264.26	263.91	264.07	6305.0
2018-04-10 05:00:00	SPY	ETF	264.13	264.32	264.0	264.3	22965.0
2018-04-10 05:30:00	SPY	ETF	264.35	264.5	264.22	264.22	16462.0
2018-04-10 06:00:00	SPY	ETF	264.14	264.29	264.01	264.27	13986.0
2018-04-10 06:30:00	SPY	ETF	264.27	264.43	264.15	264.29	80343.0
2018-04-10 07:00:00	SPY	ETF	264.2	264.38	264.1	264.21	288044.0
2018-04-10 07:30:00	SPY	ETF	264.21	264.63	264.2	264.49	455921.0
2018-04-10 08:00:00	SPY	ETF	264.48	265.07	263.75	264.16	874670.0
2018-04-10 08:30:00	SPY	ETF	264.13	264.45	263.95	264.22	534747.0
2018-04-10 09:00:00	SPY	ETF	264.21	264.41	264.14	264.3	466310.0
2018-04-10 09:30:00	SPY	ETF	264.27	264.56	263.32	263.51	10568828.0
2018-04-10 10:00:00	SPY	ETF	263.505	264.9	263.38	264.7	6806439.0
2018-04-10 10:30:00	SPY	ETF	264.7	265.45	264.7	264.9801	6397359.0
2018-04-10 11:00:00	SPY	ETF	264.97	265.5383	264.72	265.12	4860750.0
2018-04-10 11:30:00	SPY	ETF	265.1	265.76	264.18	265.22	9380826.0
2018-04-10 12:00:00	SPY	ETF	265.22	265.34	262.98	263.65	10174194.0
2018-04-10 12:30:00	SPY	ETF	263.64	264.74	263.51	264.37	5959853.0
2018-04-10 13:00:00	SPY	ETF	264.38	264.99	264.115	264.93	3885240.0
2018-04-10 13:30:00	SPY	ETF	264.92	265.28	264.09	265.17	5824363.0
2018-04-10 14:00:00	SPY	ETF	265.19	265.685	264.88	264.97	4146936.0
2018-04-10 14:30:00	SPY	ETF	264.97	265.495	264.21	265.49	7054651.0
2018-04-10 15:00:00	SPY	ETF	265.4892	266.04	265.01	265.58	7280854.0
2018-04-10 15:30:00	SPY	ETF	265.58	265.63	264.95	265.14	11324440.0
2018-04-10 16:00:00	SPY	ETF	265.13	265.1715	264.78	264.85	5749483.0
2018-04-10 16:30:00	SPY	ETF	264.88	265.15	264.79	264.86	426262.0
2018-04-10 17:00:00	SPY	ETF	264.89	265.15	264.89	264.98	841756.0
2018-04-10 17:30:00	SPY	ETF	264.94	264.94	264.8	264.88	100656.0
2018-04-10 18:00:00	SPY	ETF	264.88	264.93	264.64	264.66	55067.0
2018-04-10 18:30:00	SPY	ETF	264.66	264.86	264.56	264.67	21130.0
2018-04-10 19:00:00	SPY	ETF	264.7	264.75	264.41	264.6	112095.0
2018-04-10 19:30:00	SPY	ETF	264.64	264.8	264.05	264.34	66783.0
2018-04-10 04:00:00	QQQ	ETF	159.89	160.71	159.5	160.66	25907.0
2018-04-10 04:30:00	QQQ	ETF	160.58	160.58	160.26	160.31	11713.0
2018-04-10 05:00:00	QQQ	ETF	160.31	160.46	160.31	160.46	3900.0
2018-04-10 05:30:00	QQQ	ETF	160.55	160.63	160.43	160.43	9059.0
2018-04-10 06:00:00	QQQ	ETF	160.43	160.43	160.22	160.43	15909.0
2018-04-10 06:30:00	QQQ	ETF	160.43	160.48	160.29	160.33	24364.0
2018-04-10 07:00:00	QQQ	ETF	160.25	161.109	160.15	160.23	222849.0
2018-04-10 07:30:00	QQQ	ETF	160.25	160.48	160.21	160.32	228052.0
2018-04-10 08:00:00	QQQ	ETF	160.35	160.44	160.0	160.12	164882.0
2018-04-10 08:30:00	QQQ	ETF	160.0	160.26	159.85	160.13	141755.0
2018-04-10 09:00:00	QQQ	ETF	160.14	160.24	160.08	160.1	102576.0
2018-04-10 09:30:00	QQQ	ETF	160.11	160.46	159.1	159.3838	4941433.0
2018-04-10 10:00:00	QQQ	ETF	159.385	160.31	159.385	160.12	3129069.0
2018-04-10 10:30:00	QQQ	ETF	160.13	160.805	160.1299	160.38	3005954.0
2018-04-10 11:00:00	QQQ	ETF	160.37	160.7	160.06	160.33	2157630.0
2018-04-10 11:30:00	QQQ	ETF	160.31	160.87	159.79	160.35	3672805.0
2018-04-10 12:00:00	QQQ	ETF	160.33	160.416	159.07	159.4919	3122156.0
2018-04-10 12:30:00	QQQ	ETF	159.48	160.1749	159.4	159.95	2640730.0

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

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