PREVIEW / etf_30min / 2018-11-30

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-11-30.parquet
  size:    488 KB
  rows:    16,911

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-11-30 04:00:00	SPY	ETF	273.72	273.8	273.53	273.53	4724.0
2018-11-30 04:30:00	SPY	ETF	273.6	273.69	273.6	273.69	945.0
2018-11-30 05:00:00	SPY	ETF	273.54	273.64	273.4	273.64	5904.0
2018-11-30 05:30:00	SPY	ETF	273.68	273.68	273.35	273.35	5100.0
2018-11-30 06:00:00	SPY	ETF	273.38	273.4	273.2	273.34	47509.0
2018-11-30 06:30:00	SPY	ETF	273.37	273.4	273.08	273.2	44991.0
2018-11-30 07:00:00	SPY	ETF	273.22	273.34	273.04	273.34	107519.0
2018-11-30 07:30:00	SPY	ETF	273.3	273.43	273.26	273.3	40423.0
2018-11-30 08:00:00	SPY	ETF	273.98	274.22	273.08	273.92	590843.0
2018-11-30 08:30:00	SPY	ETF	273.9	274.19	273.71	274.02	403094.0
2018-11-30 09:00:00	SPY	ETF	274.02	274.07	273.66	273.81	305648.0
2018-11-30 09:30:00	SPY	ETF	273.81	274.259	273.45	274.18	5374954.0
2018-11-30 10:00:00	SPY	ETF	274.19	274.44	273.94	274.22	5405193.0
2018-11-30 10:30:00	SPY	ETF	274.2436	274.98	274.24	274.47	6013322.0
2018-11-30 11:00:00	SPY	ETF	274.46	274.55	273.85	274.01	3674819.0
2018-11-30 11:30:00	SPY	ETF	274.0	274.69	273.73	274.525	4434958.0
2018-11-30 12:00:00	SPY	ETF	274.53	274.59	274.16	274.225	2701389.0
2018-11-30 12:30:00	SPY	ETF	274.22	274.45	274.05	274.07	1979687.0
2018-11-30 13:00:00	SPY	ETF	274.08	274.39	273.85	274.34	2699120.0
2018-11-30 13:30:00	SPY	ETF	274.34	275.33	274.05	275.19	6276749.0
2018-11-30 14:00:00	SPY	ETF	275.19	275.385	274.96	275.2301	3811468.0
2018-11-30 14:30:00	SPY	ETF	275.24	275.5	275.06	275.27	6149796.0
2018-11-30 15:00:00	SPY	ETF	275.265	276.056	275.195	275.89	6632619.0
2018-11-30 15:30:00	SPY	ETF	275.885	276.28	275.43	275.76	20059471.0
2018-11-30 16:00:00	SPY	ETF	275.74	276.58	275.5	276.25	14791311.0
2018-11-30 16:30:00	SPY	ETF	276.34	276.55	276.2016	276.48	968082.0
2018-11-30 17:00:00	SPY	ETF	276.45	276.53	276.12	276.17	452431.0
2018-11-30 17:30:00	SPY	ETF	276.16	276.55	275.65	275.65	3062171.0
2018-11-30 18:00:00	SPY	ETF	276.42	276.45	275.65	276.25	16983.0
2018-11-30 18:30:00	SPY	ETF	276.28	276.38	276.25	276.35	12466.0
2018-11-30 19:00:00	SPY	ETF	276.32	276.39	276.32	276.32	6627.0
2018-11-30 19:30:00	SPY	ETF	276.35	276.57	276.32	276.53	30435.0
2018-11-30 04:00:00	QQQ	ETF	167.99	167.99	167.99	167.99	400.0
2018-11-30 04:30:00	QQQ	ETF	167.97	168.0	167.97	167.98	4198.0
2018-11-30 05:00:00	QQQ	ETF	167.9	168.05	167.85	168.01	10208.0
2018-11-30 05:30:00	QQQ	ETF	168.02	168.02	167.77	167.8	14755.0
2018-11-30 06:00:00	QQQ	ETF	167.77	167.78	167.63	167.72	11860.0
2018-11-30 06:30:00	QQQ	ETF	167.72	167.76	167.6	167.63	14910.0
2018-11-30 07:00:00	QQQ	ETF	167.62	167.76	167.5	167.74	51121.0
2018-11-30 07:30:00	QQQ	ETF	167.72	167.86	167.72	167.8	19885.0
2018-11-30 08:00:00	QQQ	ETF	167.62	168.43	167.56	168.15	270931.0
2018-11-30 08:30:00	QQQ	ETF	168.15	168.6	168.08	168.49	408317.0
2018-11-30 09:00:00	QQQ	ETF	168.46	168.53	168.32	168.37	178056.0
2018-11-30 09:30:00	QQQ	ETF	168.35	168.43	167.54	168.105	2632376.0
2018-11-30 10:00:00	QQQ	ETF	168.1	168.411	167.76	168.3	1535172.0
2018-11-30 10:30:00	QQQ	ETF	168.3	169.0	168.275	168.5	1832418.0
2018-11-30 11:00:00	QQQ	ETF	168.5	168.57	168.1	168.21	1916613.0
2018-11-30 11:30:00	QQQ	ETF	168.2	168.68	168.03	168.53	1544039.0
2018-11-30 12:00:00	QQQ	ETF	168.54	168.55	168.15	168.21	896491.0
2018-11-30 12:30:00	QQQ	ETF	168.21	168.33	168.02	168.04	980954.0

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

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