PREVIEW / etf_30min / 2019-03-12

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-03-12.parquet
  size:    485 KB
  rows:    17,037

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-03-12 04:00:00	SPY	ETF	279.35	279.35	279.05	279.07	3603.0
2019-03-12 04:30:00	SPY	ETF	279.07	279.07	278.93	279.0	3819.0
2019-03-12 05:00:00	SPY	ETF	279.1	279.31	279.08	279.23	3836.0
2019-03-12 05:30:00	SPY	ETF	279.21	279.25	278.92	278.92	10323.0
2019-03-12 06:00:00	SPY	ETF	278.93	278.94	278.72	278.74	10802.0
2019-03-12 06:30:00	SPY	ETF	278.71	278.82	278.71	278.74	13250.0
2019-03-12 07:00:00	SPY	ETF	278.78	278.83	278.29	278.34	319341.0
2019-03-12 07:30:00	SPY	ETF	278.34	278.5	278.34	278.5	32969.0
2019-03-12 08:00:00	SPY	ETF	279.13	279.37	278.36	278.56	255159.0
2019-03-12 08:30:00	SPY	ETF	278.69	279.28	278.69	279.17	411899.0
2019-03-12 09:00:00	SPY	ETF	279.16	279.16	278.81	279.06	319124.0
2019-03-12 09:30:00	SPY	ETF	279.06	279.58	278.85	279.3199	6842430.0
2019-03-12 10:00:00	SPY	ETF	279.32	279.62	279.06	279.62	3689336.0
2019-03-12 10:30:00	SPY	ETF	279.6125	280.0	279.525	279.76	5517592.0
2019-03-12 11:00:00	SPY	ETF	279.75	279.75	279.19	279.35	4036486.0
2019-03-12 11:30:00	SPY	ETF	279.35	279.97	279.24	279.95	3975749.0
2019-03-12 12:00:00	SPY	ETF	279.95	279.985	279.56	279.76	3594528.0
2019-03-12 12:30:00	SPY	ETF	279.76	279.79	279.43	279.63	2330134.0
2019-03-12 13:00:00	SPY	ETF	279.64	279.77	279.47	279.68	5993274.0
2019-03-12 13:30:00	SPY	ETF	279.68	280.0	279.52	279.9	2196755.0
2019-03-12 14:00:00	SPY	ETF	279.89	280.07	279.6	279.66	3920426.0
2019-03-12 14:30:00	SPY	ETF	279.66	279.81	279.61	279.775	4541933.0
2019-03-12 15:00:00	SPY	ETF	279.77	279.78	278.985	279.4	7748097.0
2019-03-12 15:30:00	SPY	ETF	279.38	279.76	279.12	279.44	11584267.0
2019-03-12 16:00:00	SPY	ETF	279.45	279.6943	279.25	279.47	9606920.0
2019-03-12 16:30:00	SPY	ETF	279.48	279.67	279.47	279.62	1332265.0
2019-03-12 17:00:00	SPY	ETF	279.62	279.64	279.49	279.49	83806.0
2019-03-12 17:30:00	SPY	ETF	279.49	279.56	279.45	279.54	85488.0
2019-03-12 18:00:00	SPY	ETF	279.53	279.56	279.28	279.29	122600.0
2019-03-12 18:30:00	SPY	ETF	279.31	279.34	279.2	279.34	19680.0
2019-03-12 19:00:00	SPY	ETF	279.35	279.39	279.2	279.26	17883.0
2019-03-12 19:30:00	SPY	ETF	279.24	279.27	279.0	279.27	51773.0
2019-03-12 04:00:00	QQQ	ETF	175.45	175.45	175.27	175.31	14327.0
2019-03-12 04:30:00	QQQ	ETF	175.3	175.3	175.11	175.21	9800.0
2019-03-12 05:00:00	QQQ	ETF	175.27	175.4	175.26	175.31	15110.0
2019-03-12 05:30:00	QQQ	ETF	175.27	175.38	175.12	175.14	19097.0
2019-03-12 06:00:00	QQQ	ETF	175.06	175.1	175.0	175.0	16700.0
2019-03-12 06:30:00	QQQ	ETF	175.03	175.07	174.96	175.0	8160.0
2019-03-12 07:00:00	QQQ	ETF	175.04	175.07	174.72	174.76	41112.0
2019-03-12 07:30:00	QQQ	ETF	174.77	174.94	174.77	174.93	19920.0
2019-03-12 08:00:00	QQQ	ETF	175.0	175.53	174.76	174.95	75814.0
2019-03-12 08:30:00	QQQ	ETF	174.94	175.42	174.94	175.32	316066.0
2019-03-12 09:00:00	QQQ	ETF	175.31	175.31	175.01	175.19	176214.0
2019-03-12 09:30:00	QQQ	ETF	175.17	175.41	174.7715	175.2689	3924265.0
2019-03-12 10:00:00	QQQ	ETF	175.27	175.38	174.99	175.37	1723739.0
2019-03-12 10:30:00	QQQ	ETF	175.38	175.96	175.37	175.78	2786978.0
2019-03-12 11:00:00	QQQ	ETF	175.76	175.77	175.3201	175.4581	2026746.0
2019-03-12 11:30:00	QQQ	ETF	175.46	176.08	175.39	176.06	2088722.0
2019-03-12 12:00:00	QQQ	ETF	176.055	176.14	175.75	176.04	2123912.0
2019-03-12 12:30:00	QQQ	ETF	176.06	176.115	175.86	175.995	1192771.0

> showing 50 of 17,037 rows — these rows as CSV

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