PREVIEW / etf_30min / 2018-03-29

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-03-29.parquet
  size:    462 KB
  rows:    15,807

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-29 04:00:00	SPY	ETF	260.63	260.63	260.23	260.23	3585.0
2018-03-29 04:30:00	SPY	ETF	260.33	260.84	260.31	260.84	3300.0
2018-03-29 05:00:00	SPY	ETF	260.82	261.04	260.57	260.94	8545.0
2018-03-29 05:30:00	SPY	ETF	260.98	261.3	260.94	261.28	11013.0
2018-03-29 06:00:00	SPY	ETF	261.18	261.23	261.14	261.23	1400.0
2018-03-29 06:30:00	SPY	ETF	261.11	261.14	260.97	260.97	54200.0
2018-03-29 07:00:00	SPY	ETF	261.04	261.15	260.95	260.96	39149.0
2018-03-29 07:30:00	SPY	ETF	260.94	261.39	260.94	261.25	97836.0
2018-03-29 08:00:00	SPY	ETF	261.07	261.25	259.49	260.95	491991.0
2018-03-29 08:30:00	SPY	ETF	260.95	261.25	260.87	261.06	440177.0
2018-03-29 09:00:00	SPY	ETF	261.05	261.22	260.88	261.11	323159.0
2018-03-29 09:30:00	SPY	ETF	261.12	261.72	260.28	260.55	10203764.0
2018-03-29 10:00:00	SPY	ETF	260.54	261.37	260.39	261.11	6459875.0
2018-03-29 10:30:00	SPY	ETF	261.11	262.75	260.93	262.74	7343046.0
2018-03-29 11:00:00	SPY	ETF	262.73	263.49	262.37	262.6	8010718.0
2018-03-29 11:30:00	SPY	ETF	262.605	263.0	262.13	262.88	4163097.0
2018-03-29 12:00:00	SPY	ETF	262.88	263.0	262.01	262.81	3878740.0
2018-03-29 12:30:00	SPY	ETF	262.81	262.98	262.3788	262.75	3727998.0
2018-03-29 13:00:00	SPY	ETF	262.75	262.99	262.23	262.86	2734710.0
2018-03-29 13:30:00	SPY	ETF	262.86	263.86	262.73	263.57	4469145.0
2018-03-29 14:00:00	SPY	ETF	263.565	264.28	263.25	263.8999	5802502.0
2018-03-29 14:30:00	SPY	ETF	263.89	264.84	263.78	264.4	9276155.0
2018-03-29 15:00:00	SPY	ETF	264.4	265.26	263.845	264.27	9537181.0
2018-03-29 15:30:00	SPY	ETF	264.26	264.7	263.4	263.49	22387680.0
2018-03-29 16:00:00	SPY	ETF	263.5	263.59	262.79	262.99	16451580.0
2018-03-29 16:30:00	SPY	ETF	262.98	264.1455	262.88	262.97	2529705.0
2018-03-29 17:00:00	SPY	ETF	262.99	263.15	262.92	262.92	727298.0
2018-03-29 17:30:00	SPY	ETF	262.91	262.99	262.8	262.97	63185.0
2018-03-29 18:00:00	SPY	ETF	263.0	263.05	262.39	262.54	223956.0
2018-03-29 18:30:00	SPY	ETF	262.53	262.67	262.53	262.67	28224.0
2018-03-29 19:00:00	SPY	ETF	262.67	262.67	262.6	262.66	11792.0
2018-03-29 19:30:00	SPY	ETF	262.67	262.79	262.6	262.65	26419.0
2018-03-29 04:00:00	QQQ	ETF	158.21	158.21	157.99	157.99	15837.0
2018-03-29 04:30:00	QQQ	ETF	158.1	158.39	158.09	158.39	9600.0
2018-03-29 05:00:00	QQQ	ETF	158.35	158.49	158.14	158.49	4400.0
2018-03-29 05:30:00	QQQ	ETF	158.39	158.85	158.39	158.78	10150.0
2018-03-29 06:00:00	QQQ	ETF	158.79	158.79	158.55	158.62	19611.0
2018-03-29 06:30:00	QQQ	ETF	158.54	158.54	158.32	158.34	8428.0
2018-03-29 07:00:00	QQQ	ETF	158.34	158.6	158.34	158.47	69989.0
2018-03-29 07:30:00	QQQ	ETF	158.51	158.93	158.44	158.71	226266.0
2018-03-29 08:00:00	QQQ	ETF	158.67	158.74	158.02	158.22	318307.0
2018-03-29 08:30:00	QQQ	ETF	158.34	158.7	158.2	158.41	298280.0
2018-03-29 09:00:00	QQQ	ETF	158.35	158.47	158.07	158.16	248874.0
2018-03-29 09:30:00	QQQ	ETF	158.14	158.59	156.6338	156.95	7219339.0
2018-03-29 10:00:00	QQQ	ETF	156.97	157.91	156.8	157.68	4324379.0
2018-03-29 10:30:00	QQQ	ETF	157.69	159.57	157.59	159.57	4780702.0
2018-03-29 11:00:00	QQQ	ETF	159.56	159.88	158.97	159.23	5426789.0
2018-03-29 11:30:00	QQQ	ETF	159.22	159.37	158.66	159.255	2951080.0
2018-03-29 12:00:00	QQQ	ETF	159.26	159.44	158.49	159.42	2477735.0
2018-03-29 12:30:00	QQQ	ETF	159.44	159.6301	159.04	159.46	1324543.0

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

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