PREVIEW / etf_30min / 2019-01-03

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-01-03.parquet
  size:    509 KB
  rows:    18,016

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-01-03 04:00:00	SPY	ETF	246.82	247.12	246.77	246.8	29482.0
2019-01-03 04:30:00	SPY	ETF	246.85	246.85	246.25	246.32	32819.0
2019-01-03 05:00:00	SPY	ETF	246.27	246.3	245.97	246.27	43912.0
2019-01-03 05:30:00	SPY	ETF	246.38	246.55	246.09	246.09	10758.0
2019-01-03 06:00:00	SPY	ETF	246.11	246.99	245.9	246.26	59787.0
2019-01-03 06:30:00	SPY	ETF	246.2	246.48	245.89	246.47	100007.0
2019-01-03 07:00:00	SPY	ETF	246.39	246.96	246.39	246.8	219440.0
2019-01-03 07:30:00	SPY	ETF	246.85	247.3	246.84	247.25	245106.0
2019-01-03 08:00:00	SPY	ETF	246.7301	248.17	245.7	247.65	557261.0
2019-01-03 08:30:00	SPY	ETF	247.62	248.26	247.48	248.1	718581.0
2019-01-03 09:00:00	SPY	ETF	248.12	248.47	247.81	248.27	630170.0
2019-01-03 09:30:00	SPY	ETF	248.23	248.57	246.78	247.25	11147369.0
2019-01-03 10:00:00	SPY	ETF	247.18	247.235	244.75	245.65	15407895.0
2019-01-03 10:30:00	SPY	ETF	245.65	245.65	244.03	245.35	9720236.0
2019-01-03 11:00:00	SPY	ETF	245.36	246.54	245.04	245.69	9828126.0
2019-01-03 11:30:00	SPY	ETF	245.695	248.18	245.43	247.12	10450038.0
2019-01-03 12:00:00	SPY	ETF	247.1115	247.34	246.32	246.61	5757703.0
2019-01-03 12:30:00	SPY	ETF	246.62	247.28	246.03	247.04	4776916.0
2019-01-03 13:00:00	SPY	ETF	247.03	247.05	244.79	245.71	7119644.0
2019-01-03 13:30:00	SPY	ETF	245.71	246.4285	244.93	245.21	4886240.0
2019-01-03 14:00:00	SPY	ETF	245.2	246.35	244.99	246.28	5151497.0
2019-01-03 14:30:00	SPY	ETF	246.3	246.65	244.54	244.9	5520465.0
2019-01-03 15:00:00	SPY	ETF	244.9	245.08	244.2	244.62	7298762.0
2019-01-03 15:30:00	SPY	ETF	244.62	245.43	243.67	244.13	21569101.0
2019-01-03 16:00:00	SPY	ETF	244.11	244.79	243.96	244.2	14331020.0
2019-01-03 16:30:00	SPY	ETF	244.21	244.54	243.97	244.46	3585540.0
2019-01-03 17:00:00	SPY	ETF	244.39	244.43	244.21	244.31	1147954.0
2019-01-03 17:30:00	SPY	ETF	244.28	244.33	244.19	244.33	1785227.0
2019-01-03 18:00:00	SPY	ETF	244.33	244.72	244.2	244.64	77259.0
2019-01-03 18:30:00	SPY	ETF	244.65	244.84	244.1	244.21	71118.0
2019-01-03 19:00:00	SPY	ETF	244.21	244.39	243.19	243.34	112555.0
2019-01-03 19:30:00	SPY	ETF	243.35	243.66	243.27	243.54	106400.0
2019-01-03 04:00:00	QQQ	ETF	150.88	151.1	150.87	150.98	22299.0
2019-01-03 04:30:00	QQQ	ETF	150.98	150.98	150.68	150.73	27360.0
2019-01-03 05:00:00	QQQ	ETF	150.67	150.73	150.44	150.73	49470.0
2019-01-03 05:30:00	QQQ	ETF	150.74	151.01	150.53	150.63	41045.0
2019-01-03 06:00:00	QQQ	ETF	150.68	150.93	150.57	150.68	36215.0
2019-01-03 06:30:00	QQQ	ETF	150.74	150.92	150.57	150.92	47108.0
2019-01-03 07:00:00	QQQ	ETF	150.92	151.59	150.89	151.57	202806.0
2019-01-03 07:30:00	QQQ	ETF	151.56	151.84	151.55	151.81	157311.0
2019-01-03 08:00:00	QQQ	ETF	151.2	152.4	150.51	152.19	452258.0
2019-01-03 08:30:00	QQQ	ETF	152.23	152.49	152.06	152.39	281921.0
2019-01-03 09:00:00	QQQ	ETF	152.4	152.68	152.13	152.64	410958.0
2019-01-03 09:30:00	QQQ	ETF	152.63	153.26	151.65	152.01	7803994.0
2019-01-03 10:00:00	QQQ	ETF	151.99	152.01	150.4	151.32	7795838.0
2019-01-03 10:30:00	QQQ	ETF	151.31	151.32	150.0	151.0015	5254644.0
2019-01-03 11:00:00	QQQ	ETF	151.02	152.0	150.9	151.36	5228424.0
2019-01-03 11:30:00	QQQ	ETF	151.37	152.75	151.12	152.03	4983206.0
2019-01-03 12:00:00	QQQ	ETF	152.04	152.28	151.31	151.5	3012261.0
2019-01-03 12:30:00	QQQ	ETF	151.5	152.03	151.17	151.86	2236525.0

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

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