PREVIEW / etf_30min / 2018-03-26

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-03-26.parquet
  size:    481 KB
  rows:    16,588

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-03-26 04:00:00	SPY	ETF	261.35	262.18	260.25	262.01	44629.0
2018-03-26 04:30:00	SPY	ETF	261.99	262.14	261.68	261.7	29894.0
2018-03-26 05:00:00	SPY	ETF	261.63	262.0	261.52	261.9	11043.0
2018-03-26 05:30:00	SPY	ETF	261.89	262.6	261.89	262.42	52797.0
2018-03-26 06:00:00	SPY	ETF	262.46	262.5	262.23	262.26	55881.0
2018-03-26 06:30:00	SPY	ETF	262.25	262.33	261.88	262.2	136232.0
2018-03-26 07:00:00	SPY	ETF	262.22	262.75	262.0	262.13	318226.0
2018-03-26 07:30:00	SPY	ETF	262.15	262.2	261.87	262.12	201085.0
2018-03-26 08:00:00	SPY	ETF	262.15	262.95	261.95	262.41	608828.0
2018-03-26 08:30:00	SPY	ETF	262.42	262.54	262.05	262.09	397339.0
2018-03-26 09:00:00	SPY	ETF	262.06	262.18	261.76	262.18	1105041.0
2018-03-26 09:30:00	SPY	ETF	262.13	263.17	262.09	262.63	12199550.0
2018-03-26 10:00:00	SPY	ETF	262.63	262.95	261.46	261.5199	10593377.0
2018-03-26 10:30:00	SPY	ETF	261.51	261.78	260.83	261.09	10819443.0
2018-03-26 11:00:00	SPY	ETF	261.08	261.35	259.41	260.21	8891881.0
2018-03-26 11:30:00	SPY	ETF	260.19	261.34	259.92	261.0011	8182870.0
2018-03-26 12:00:00	SPY	ETF	261.0	262.05	260.57	261.74	5534129.0
2018-03-26 12:30:00	SPY	ETF	261.75	262.37	261.255	261.4	9221134.0
2018-03-26 13:00:00	SPY	ETF	261.4	262.58	261.355	261.99	5602296.0
2018-03-26 13:30:00	SPY	ETF	262.0	262.34	261.54	262.02	5671052.0
2018-03-26 14:00:00	SPY	ETF	262.02	263.52	261.98	263.47	6689668.0
2018-03-26 14:30:00	SPY	ETF	263.48	264.05	263.18	263.59	6262873.0
2018-03-26 15:00:00	SPY	ETF	263.59	264.58	263.52	264.55	7592298.0
2018-03-26 15:30:00	SPY	ETF	264.54	265.43	264.4	265.17	19250367.0
2018-03-26 16:00:00	SPY	ETF	265.15	265.23	261.9375	265.08	12865450.0
2018-03-26 16:30:00	SPY	ETF	265.06	265.14	261.3177	262.5876	5587796.0
2018-03-26 17:00:00	SPY	ETF	265.07	265.13	264.97	265.05	281124.0
2018-03-26 17:30:00	SPY	ETF	265.06	265.11	264.95	265.04	219737.0
2018-03-26 18:00:00	SPY	ETF	265.07	265.41	265.04	265.39	100806.0
2018-03-26 18:30:00	SPY	ETF	265.39	265.39	265.15	265.19	8120.0
2018-03-26 19:00:00	SPY	ETF	265.2	265.23	264.84	265.1	41302.0
2018-03-26 19:30:00	SPY	ETF	265.02	265.38	261.975	265.33	540727.0
2018-03-26 04:00:00	QQQ	ETF	159.75	161.58	159.75	161.51	26724.0
2018-03-26 04:30:00	QQQ	ETF	161.46	161.55	161.29	161.36	13008.0
2018-03-26 05:00:00	QQQ	ETF	161.3	161.55	161.21	161.49	14147.0
2018-03-26 05:30:00	QQQ	ETF	161.48	162.01	161.45	161.94	51766.0
2018-03-26 06:00:00	QQQ	ETF	161.94	161.94	161.73	161.75	23900.0
2018-03-26 06:30:00	QQQ	ETF	161.71	161.73	161.43	161.7	97349.0
2018-03-26 07:00:00	QQQ	ETF	161.71	162.06	161.6	161.8	131438.0
2018-03-26 07:30:00	QQQ	ETF	161.76	161.8	161.56	161.74	100899.0
2018-03-26 08:00:00	QQQ	ETF	161.71	162.23	161.615	161.89	279684.0
2018-03-26 08:30:00	QQQ	ETF	161.87	161.99	161.63	161.63	128495.0
2018-03-26 09:00:00	QQQ	ETF	161.62	161.69	161.42	161.67	367370.0
2018-03-26 09:30:00	QQQ	ETF	161.68	162.31	161.66	161.93	6859963.0
2018-03-26 10:00:00	QQQ	ETF	161.91	162.2	161.15	161.2	3978062.0
2018-03-26 10:30:00	QQQ	ETF	161.18	161.33	160.52	160.79	4380333.0
2018-03-26 11:00:00	QQQ	ETF	160.795	160.88	159.16	159.9598	3973818.0
2018-03-26 11:30:00	QQQ	ETF	159.94	161.05	159.76	160.7	2751891.0
2018-03-26 12:00:00	QQQ	ETF	160.7	161.43	160.26	161.26	2731325.0
2018-03-26 12:30:00	QQQ	ETF	161.27	161.605	160.93	161.09	1721310.0

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

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