PREVIEW / etf_30min / 2019-11-29

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-11-29.parquet
  size:    301 KB
  rows:    10,251

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
2019-11-29 04:00:00	SPY	ETF	314.8	314.89	314.74	314.86	3566.0
2019-11-29 04:30:00	SPY	ETF	314.82	314.87	314.78	314.87	5571.0
2019-11-29 05:00:00	SPY	ETF	314.83	314.84	314.76	314.81	3080.0
2019-11-29 05:30:00	SPY	ETF	314.87	314.87	314.73	314.79	2100.0
2019-11-29 06:00:00	SPY	ETF	314.76	314.79	314.76	314.79	3435.0
2019-11-29 06:30:00	SPY	ETF	314.81	314.9	314.79	314.79	8826.0
2019-11-29 07:00:00	SPY	ETF	314.81	315.0	314.81	315.0	14109.0
2019-11-29 07:30:00	SPY	ETF	314.99	315.03	314.91	315.01	22218.0
2019-11-29 08:00:00	SPY	ETF	314.8899	315.02	314.35	314.92	45130.0
2019-11-29 08:30:00	SPY	ETF	314.92	315.07	314.9	314.91	62772.0
2019-11-29 09:00:00	SPY	ETF	314.9	314.99	314.87	314.87	237973.0
2019-11-29 09:30:00	SPY	ETF	314.86	315.13	314.5869	314.975	4439257.0
2019-11-29 10:00:00	SPY	ETF	314.97	315.12	314.83	314.94	3671691.0
2019-11-29 10:30:00	SPY	ETF	314.94	315.03	314.8	314.87	2654499.0
2019-11-29 11:00:00	SPY	ETF	314.865	314.885	314.63	314.7	1398940.0
2019-11-29 11:30:00	SPY	ETF	314.7	314.84	314.42	314.75	2572699.0
2019-11-29 12:00:00	SPY	ETF	314.75	314.82	314.44	314.45	2693926.0
2019-11-29 12:30:00	SPY	ETF	314.45	314.58	314.06	314.27	7432587.0
2019-11-29 13:00:00	SPY	ETF	314.27	314.57	314.26	314.5	2608605.0
2019-11-29 13:30:00	SPY	ETF	314.47	314.76	314.31	314.47	791957.0
2019-11-29 14:00:00	SPY	ETF	314.5	314.6	314.4301	314.4301	70425.0
2019-11-29 14:30:00	SPY	ETF	314.44	314.6	314.43	314.6	18091.0
2019-11-29 15:00:00	SPY	ETF	314.59	314.6	314.51	314.6	3596.0
2019-11-29 15:30:00	SPY	ETF	314.5833	314.5833	314.32	314.5	23391.0
2019-11-29 16:00:00	SPY	ETF	314.49	314.5	314.44	314.44	1798.0
2019-11-29 16:30:00	SPY	ETF	314.46	314.62	314.45	314.6	11019.0
2019-11-29 04:00:00	QQQ	ETF	205.6	205.65	205.53	205.53	9264.0
2019-11-29 04:30:00	QQQ	ETF	205.6	205.6	205.5	205.59	3100.0
2019-11-29 05:00:00	QQQ	ETF	205.57	205.63	205.55	205.63	942.0
2019-11-29 05:30:00	QQQ	ETF	205.63	205.65	205.5	205.54	2900.0
2019-11-29 06:00:00	QQQ	ETF	205.58	205.66	205.55	205.66	600.0
2019-11-29 06:30:00	QQQ	ETF	205.65	205.73	205.65	205.67	3492.0
2019-11-29 07:00:00	QQQ	ETF	205.69	205.76	205.65	205.75	10774.0
2019-11-29 07:30:00	QQQ	ETF	205.74	205.75	205.67	205.7	13677.0
2019-11-29 08:00:00	QQQ	ETF	205.7	205.78	205.26	205.61	24134.0
2019-11-29 08:30:00	QQQ	ETF	205.61	205.73	205.57	205.58	22421.0
2019-11-29 09:00:00	QQQ	ETF	205.54	205.68	205.54	205.57	40581.0
2019-11-29 09:30:00	QQQ	ETF	205.57	205.8	205.38	205.7701	1373228.0
2019-11-29 10:00:00	QQQ	ETF	205.76	205.83	205.58	205.6	599591.0
2019-11-29 10:30:00	QQQ	ETF	205.61	205.73	205.45	205.59	520332.0
2019-11-29 11:00:00	QQQ	ETF	205.5801	205.5944	205.4	205.49	588476.0
2019-11-29 11:30:00	QQQ	ETF	205.48	205.5466	205.27	205.53	602562.0
2019-11-29 12:00:00	QQQ	ETF	205.53	205.54	205.14	205.14	663681.0
2019-11-29 12:30:00	QQQ	ETF	205.135	205.35	205.0	205.08	1832632.0
2019-11-29 13:00:00	QQQ	ETF	205.06	205.4	205.0236	205.2951	835410.0
2019-11-29 13:30:00	QQQ	ETF	205.2713	205.4	205.1	205.28	44777.0
2019-11-29 14:00:00	QQQ	ETF	205.2539	205.5	205.2	205.35	42982.0
2019-11-29 14:30:00	QQQ	ETF	205.35	205.36	205.31	205.36	2234.0
2019-11-29 15:00:00	QQQ	ETF	205.37	205.38	205.3	205.31	4198.0
2019-11-29 15:30:00	QQQ	ETF	205.28	205.38	205.2	205.2	9525.0

> showing 50 of 10,251 rows — these rows as CSV

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