PREVIEW / etf_30min / 2019-11-20

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-11-20.parquet
  size:    525 KB
  rows:    18,417

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-20 04:00:00	SPY	ETF	310.64	310.78	310.49	310.78	7550.0
2019-11-20 04:30:00	SPY	ETF	310.94	310.99	310.84	310.89	3552.0
2019-11-20 05:00:00	SPY	ETF	310.83	310.83	310.6	310.63	6200.0
2019-11-20 05:30:00	SPY	ETF	310.58	310.7	310.58	310.68	59660.0
2019-11-20 06:00:00	SPY	ETF	310.77	310.77	310.39	310.5	38809.0
2019-11-20 06:30:00	SPY	ETF	310.52	311.08	310.52	311.08	93073.0
2019-11-20 07:00:00	SPY	ETF	311.04	311.2	310.93	311.09	73959.0
2019-11-20 07:30:00	SPY	ETF	311.09	311.16	310.88	310.93	45579.0
2019-11-20 08:00:00	SPY	ETF	311.04	311.46	310.66	311.11	72178.0
2019-11-20 08:30:00	SPY	ETF	311.11	311.2	310.81	310.84	122633.0
2019-11-20 09:00:00	SPY	ETF	310.83	311.31	310.82	311.28	218058.0
2019-11-20 09:30:00	SPY	ETF	311.28	311.62	311.21	311.5	4031814.0
2019-11-20 10:00:00	SPY	ETF	311.5	311.64	311.07	311.38	3651990.0
2019-11-20 10:30:00	SPY	ETF	311.38	311.85	311.38	311.65	3615114.0
2019-11-20 11:00:00	SPY	ETF	311.655	311.78	311.4	311.58	1947465.0
2019-11-20 11:30:00	SPY	ETF	311.58	311.62	311.27	311.365	3347556.0
2019-11-20 12:00:00	SPY	ETF	311.36	311.47	311.16	311.3042	2258812.0
2019-11-20 12:30:00	SPY	ETF	311.305	311.41	309.53	310.17	6390278.0
2019-11-20 13:00:00	SPY	ETF	310.17	310.28	309.06	309.39	10380401.0
2019-11-20 13:30:00	SPY	ETF	309.39	310.2	309.1475	309.99	6486667.0
2019-11-20 14:00:00	SPY	ETF	310.0	310.43	309.64	310.4	5841884.0
2019-11-20 14:30:00	SPY	ETF	310.39	310.695	310.3	310.38	3385201.0
2019-11-20 15:00:00	SPY	ETF	310.38	310.79	310.25	310.25	4176842.0
2019-11-20 15:30:00	SPY	ETF	310.24	310.92	310.15	310.79	10926218.0
2019-11-20 16:00:00	SPY	ETF	310.79	311.945	310.53	310.87	9863725.0
2019-11-20 16:30:00	SPY	ETF	310.87	310.93	310.75	310.85	303979.0
2019-11-20 17:00:00	SPY	ETF	310.8	310.82	310.1	310.12	431295.0
2019-11-20 17:30:00	SPY	ETF	310.2	310.3	309.6	309.81	261208.0
2019-11-20 18:00:00	SPY	ETF	309.81	310.22	309.4	310.15	289988.0
2019-11-20 18:30:00	SPY	ETF	310.19	310.33	310.15	310.16	39515.0
2019-11-20 19:00:00	SPY	ETF	310.2	310.29	309.95	309.98	36733.0
2019-11-20 19:30:00	SPY	ETF	309.96	310.12	309.41	309.48	112089.0
2019-11-20 04:00:00	QQQ	ETF	202.34	202.38	202.13	202.38	17459.0
2019-11-20 04:30:00	QQQ	ETF	202.45	202.48	202.4	202.44	7600.0
2019-11-20 05:00:00	QQQ	ETF	202.42	202.44	202.21	202.39	8600.0
2019-11-20 05:30:00	QQQ	ETF	202.31	202.4	202.25	202.36	36150.0
2019-11-20 06:00:00	QQQ	ETF	202.37	202.37	202.11	202.2	12820.0
2019-11-20 06:30:00	QQQ	ETF	202.25	202.56	202.25	202.54	14250.0
2019-11-20 07:00:00	QQQ	ETF	202.55	202.7	202.46	202.59	53247.0
2019-11-20 07:30:00	QQQ	ETF	202.59	202.7	202.41	202.52	90455.0
2019-11-20 08:00:00	QQQ	ETF	202.62	203.37	202.36	202.68	1142080.0
2019-11-20 08:30:00	QQQ	ETF	202.7	202.74	202.37	202.46	180907.0
2019-11-20 09:00:00	QQQ	ETF	202.43	202.88	202.4	202.87	135321.0
2019-11-20 09:30:00	QQQ	ETF	202.85	203.1	202.71	203.0794	3679862.0
2019-11-20 10:00:00	QQQ	ETF	203.08	203.2239	202.8	203.08	2509120.0
2019-11-20 10:30:00	QQQ	ETF	203.08	203.45	203.08	203.32	1263209.0
2019-11-20 11:00:00	QQQ	ETF	203.33	203.42	203.02	203.07	497660.0
2019-11-20 11:30:00	QQQ	ETF	203.07	203.13	202.79	202.86	722396.0
2019-11-20 12:00:00	QQQ	ETF	202.86	202.95	202.7	202.856	584032.0
2019-11-20 12:30:00	QQQ	ETF	202.87	203.03	201.255	201.8027	3117312.0

> showing 50 of 18,417 rows — these rows as CSV

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