PREVIEW / etf_30min / 2018-06-12

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-06-12.parquet
  size:    459 KB
  rows:    15,827

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-06-12 04:00:00	SPY	ETF	278.86	278.91	278.52	278.55	2352.0
2018-06-12 04:30:00	SPY	ETF	278.58	278.68	278.36	278.48	10312.0
2018-06-12 05:00:00	SPY	ETF	278.62	278.62	278.53	278.6	3786.0
2018-06-12 05:30:00	SPY	ETF	278.53	278.53	278.33	278.46	9012.0
2018-06-12 06:00:00	SPY	ETF	278.25	278.36	278.24	278.36	16702.0
2018-06-12 06:30:00	SPY	ETF	278.37	278.39	278.3	278.36	20990.0
2018-06-12 07:00:00	SPY	ETF	278.4	278.47	278.24	278.32	70129.0
2018-06-12 07:30:00	SPY	ETF	278.35	278.71	278.35	278.71	77337.0
2018-06-12 08:00:00	SPY	ETF	278.72	279.04	278.39	278.63	134531.0
2018-06-12 08:30:00	SPY	ETF	278.61	278.94	278.59	278.93	140652.0
2018-06-12 09:00:00	SPY	ETF	278.94	279.08	278.86	279.07	686590.0
2018-06-12 09:30:00	SPY	ETF	279.03	279.08	278.56	278.68	5946438.0
2018-06-12 10:00:00	SPY	ETF	278.69	279.02	278.63	278.69	2695470.0
2018-06-12 10:30:00	SPY	ETF	278.68	278.91	278.6401	278.905	2391820.0
2018-06-12 11:00:00	SPY	ETF	278.91	278.94	278.6	278.835	6399439.0
2018-06-12 11:30:00	SPY	ETF	278.845	279.24	278.81	279.19	3804435.0
2018-06-12 12:00:00	SPY	ETF	279.2	279.33	279.11	279.12	2436647.0
2018-06-12 12:30:00	SPY	ETF	279.12	279.15	278.98	279.07	3324483.0
2018-06-12 13:00:00	SPY	ETF	279.06	279.15	278.885	278.92	2063003.0
2018-06-12 13:30:00	SPY	ETF	278.92	279.09	278.81	279.08	3015548.0
2018-06-12 14:00:00	SPY	ETF	279.08	279.0899	278.39	278.44	2428455.0
2018-06-12 14:30:00	SPY	ETF	278.44	278.7	278.22	278.23	6465706.0
2018-06-12 15:00:00	SPY	ETF	278.2399	278.77	278.19	278.75	6617842.0
2018-06-12 15:30:00	SPY	ETF	278.75	279.07	278.64	278.98	11373044.0
2018-06-12 16:00:00	SPY	ETF	278.99	279.011	278.7	278.78	8544167.0
2018-06-12 16:30:00	SPY	ETF	278.75	279.27	278.75	279.15	716811.0
2018-06-12 17:00:00	SPY	ETF	279.14	279.17	279.0	279.07	401364.0
2018-06-12 17:30:00	SPY	ETF	279.12	279.22	279.07	279.09	51569.0
2018-06-12 18:00:00	SPY	ETF	279.13	279.2	279.0	279.2	42972.0
2018-06-12 18:30:00	SPY	ETF	279.2	279.25	279.19	279.19	1570.0
2018-06-12 19:00:00	SPY	ETF	279.19	279.2	279.18	279.2	7250.0
2018-06-12 19:30:00	SPY	ETF	279.18	279.28	279.0108	279.22	134920.0
2018-06-12 04:00:00	QQQ	ETF	174.88	175.1	174.76	174.8	2200.0
2018-06-12 04:30:00	QQQ	ETF	174.87	174.9	174.64	174.74	60396.0
2018-06-12 05:00:00	QQQ	ETF	174.67	174.82	174.65	174.82	20800.0
2018-06-12 05:30:00	QQQ	ETF	174.8	174.8	174.63	174.74	5350.0
2018-06-12 06:00:00	QQQ	ETF	174.61	175.0	174.59	174.59	5900.0
2018-06-12 06:30:00	QQQ	ETF	174.69	174.69	174.58	174.68	16400.0
2018-06-12 07:00:00	QQQ	ETF	174.72	174.77	174.63	174.7	9932.0
2018-06-12 07:30:00	QQQ	ETF	174.68	174.87	174.68	174.86	19800.0
2018-06-12 08:00:00	QQQ	ETF	174.72	174.88	174.68	174.8	47990.0
2018-06-12 08:30:00	QQQ	ETF	174.8	175.12	174.79	175.12	75990.0
2018-06-12 09:00:00	QQQ	ETF	175.14	175.2	175.09	175.17	89941.0
2018-06-12 09:30:00	QQQ	ETF	175.15	175.47	174.96	175.02	2373829.0
2018-06-12 10:00:00	QQQ	ETF	175.015	175.34	174.98	175.07	1125027.0
2018-06-12 10:30:00	QQQ	ETF	175.07	175.39	175.07	175.37	1169904.0
2018-06-12 11:00:00	QQQ	ETF	175.38	175.48	175.19	175.3999	1038887.0
2018-06-12 11:30:00	QQQ	ETF	175.4	175.8049	175.36	175.75	1049045.0
2018-06-12 12:00:00	QQQ	ETF	175.7515	175.84	175.68	175.7	1078529.0
2018-06-12 12:30:00	QQQ	ETF	175.71	175.77	175.64	175.73	517724.0

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

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