PREVIEW / etf_30min / 2020-07-14

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-07-14.parquet
  size:    550 KB
  rows:    20,750

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
2020-07-14 04:00:00	SPY	ETF	314.91	316.15	314.9	316.05	31818.0
2020-07-14 04:30:00	SPY	ETF	316.03	316.25	315.85	315.93	7246.0
2020-07-14 05:00:00	SPY	ETF	315.93	316.3	315.5	316.3	25904.0
2020-07-14 05:30:00	SPY	ETF	316.23	316.23	315.81	315.96	7220.0
2020-07-14 06:00:00	SPY	ETF	315.96	316.12	315.67	315.83	130436.0
2020-07-14 06:30:00	SPY	ETF	315.8	316.07	315.54	316.06	85964.0
2020-07-14 07:00:00	SPY	ETF	316.18	316.37	315.55	316.27	158613.0
2020-07-14 07:30:00	SPY	ETF	316.24	316.48	315.81	316.2	198902.0
2020-07-14 08:00:00	SPY	ETF	315.9804	316.5	314.9	315.77	472341.0
2020-07-14 08:30:00	SPY	ETF	315.71	315.76	313.71	313.77	584691.0
2020-07-14 09:00:00	SPY	ETF	313.77	314.25	313.1	313.29	917820.0
2020-07-14 09:30:00	SPY	ETF	313.3	315.31	312.0	313.89	11004156.0
2020-07-14 10:00:00	SPY	ETF	313.84	314.355	312.33	314.32	6981506.0
2020-07-14 10:30:00	SPY	ETF	314.3	315.92	314.28	314.82	6468356.0
2020-07-14 11:00:00	SPY	ETF	314.875	315.81	314.3	315.29	4987014.0
2020-07-14 11:30:00	SPY	ETF	315.31	316.67	315.09	316.0	4180353.0
2020-07-14 12:00:00	SPY	ETF	316.0	316.64	315.29	315.885	2690747.0
2020-07-14 12:30:00	SPY	ETF	315.9086	316.33	315.15	315.31	3236123.0
2020-07-14 13:00:00	SPY	ETF	315.32	315.75	314.52	315.51	2601183.0
2020-07-14 13:30:00	SPY	ETF	315.51	316.99	315.41	316.34	5117532.0
2020-07-14 14:00:00	SPY	ETF	316.34	317.67	315.9	317.24	5829959.0
2020-07-14 14:30:00	SPY	ETF	317.24	317.62	316.42	317.4	3402123.0
2020-07-14 15:00:00	SPY	ETF	317.42	317.56	315.77	317.3375	6423354.0
2020-07-14 15:30:00	SPY	ETF	317.35	319.76	317.18	318.89	16885833.0
2020-07-14 16:00:00	SPY	ETF	318.9	319.0966	318.36	318.49	7718254.0
2020-07-14 16:30:00	SPY	ETF	318.46	318.93	318.25	318.52	212418.0
2020-07-14 17:00:00	SPY	ETF	318.52	321.85	318.52	320.7	944971.0
2020-07-14 17:30:00	SPY	ETF	320.88	321.24	320.52	320.59	566391.0
2020-07-14 18:00:00	SPY	ETF	320.55	321.56	320.45	321.35	345835.0
2020-07-14 18:30:00	SPY	ETF	321.36	321.56	320.93	321.28	198690.0
2020-07-14 19:00:00	SPY	ETF	321.28	321.41	321.02	321.07	87257.0
2020-07-14 19:30:00	SPY	ETF	321.1	321.1	320.62	321.04	119899.0
2020-07-14 04:00:00	QQQ	ETF	258.58	259.63	258.57	259.63	37586.0
2020-07-14 04:30:00	QQQ	ETF	259.54	259.84	259.4	259.52	19203.0
2020-07-14 05:00:00	QQQ	ETF	259.47	259.7	259.0	259.7	43059.0
2020-07-14 05:30:00	QQQ	ETF	259.7	259.75	259.21	259.36	16967.0
2020-07-14 06:00:00	QQQ	ETF	259.43	259.47	259.13	259.18	43772.0
2020-07-14 06:30:00	QQQ	ETF	259.13	259.13	258.74	258.91	53620.0
2020-07-14 07:00:00	QQQ	ETF	258.96	259.28	258.45	259.19	231101.0
2020-07-14 07:30:00	QQQ	ETF	259.2	260.42	259.2	260.08	195871.0
2020-07-14 08:00:00	QQQ	ETF	260.05	260.95	258.53	259.3	358299.0
2020-07-14 08:30:00	QQQ	ETF	259.3	259.32	256.29	256.46	945863.0
2020-07-14 09:00:00	QQQ	ETF	256.51	256.85	255.36	256.04	989609.0
2020-07-14 09:30:00	QQQ	ETF	256.07	259.36	253.43	255.59	12967371.0
2020-07-14 10:00:00	QQQ	ETF	255.54	255.85	252.76	255.4458	7420984.0
2020-07-14 10:30:00	QQQ	ETF	255.43	257.92	255.32	256.27	5690236.0
2020-07-14 11:00:00	QQQ	ETF	256.265	257.45	255.31	257.125	3832740.0
2020-07-14 11:30:00	QQQ	ETF	257.13	258.66	256.77	257.66	2690833.0
2020-07-14 12:00:00	QQQ	ETF	257.65	258.82	257.13	257.86	2051221.0
2020-07-14 12:30:00	QQQ	ETF	257.86	258.42	256.62	256.86	1523188.0

> showing 50 of 20,750 rows — these rows as CSV

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