PREVIEW / etf_30min / 2019-01-04

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-01-04.parquet
  size:    514 KB
  rows:    18,063

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-04 04:00:00	SPY	ETF	246.5	247.43	246.28	247.43	50242.0
2019-01-04 04:30:00	SPY	ETF	247.34	247.59	247.06	247.1	26168.0
2019-01-04 05:00:00	SPY	ETF	247.12	247.3	247.0	247.05	20189.0
2019-01-04 05:30:00	SPY	ETF	247.03	247.69	246.95	247.62	19029.0
2019-01-04 06:00:00	SPY	ETF	247.59	247.93	247.24	247.75	54124.0
2019-01-04 06:30:00	SPY	ETF	247.75	247.8	247.41	247.55	231286.0
2019-01-04 07:00:00	SPY	ETF	247.52	247.68	247.24	247.34	183965.0
2019-01-04 07:30:00	SPY	ETF	247.33	247.42	247.0	247.14	249061.0
2019-01-04 08:00:00	SPY	ETF	247.15	247.64	245.3	247.39	566838.0
2019-01-04 08:30:00	SPY	ETF	247.47	247.66	246.34	247.15	1505974.0
2019-01-04 09:00:00	SPY	ETF	247.14	247.88	246.82	247.58	621466.0
2019-01-04 09:30:00	SPY	ETF	247.59	249.16	247.17	249.115	13394087.0
2019-01-04 10:00:00	SPY	ETF	249.125	250.97	248.02	250.96	15739986.0
2019-01-04 10:30:00	SPY	ETF	250.96	251.35	250.1	251.03	11194039.0
2019-01-04 11:00:00	SPY	ETF	251.03	251.86	250.34	250.59	8419432.0
2019-01-04 11:30:00	SPY	ETF	250.58	251.55	250.25	251.2	5369031.0
2019-01-04 12:00:00	SPY	ETF	251.18	252.12	250.61	251.89	5540292.0
2019-01-04 12:30:00	SPY	ETF	251.87	252.72	251.6	252.42	6694228.0
2019-01-04 13:00:00	SPY	ETF	252.43	253.11	252.425	252.6	8698869.0
2019-01-04 13:30:00	SPY	ETF	252.6	252.99	251.75	252.16	8401438.0
2019-01-04 14:00:00	SPY	ETF	252.16	252.5	251.5	252.39	5330835.0
2019-01-04 14:30:00	SPY	ETF	252.39	252.79	251.56	251.65	7518465.0
2019-01-04 15:00:00	SPY	ETF	251.655	252.58	251.47	251.765	9802464.0
2019-01-04 15:30:00	SPY	ETF	251.78	252.65	251.62	252.47	18813959.0
2019-01-04 16:00:00	SPY	ETF	252.46	252.63	252.103	252.26	8919258.0
2019-01-04 16:30:00	SPY	ETF	252.26	253.05	252.0	252.2	430463.0
2019-01-04 17:00:00	SPY	ETF	252.2	252.39	252.2	252.34	2199198.0
2019-01-04 17:30:00	SPY	ETF	252.3	252.39	252.26	252.39	14895.0
2019-01-04 18:00:00	SPY	ETF	252.33	253.04	252.33	252.43	113904.0
2019-01-04 18:30:00	SPY	ETF	252.49	252.61	252.44	252.56	10903.0
2019-01-04 19:00:00	SPY	ETF	252.56	252.68	252.54	252.67	9967.0
2019-01-04 19:30:00	SPY	ETF	252.68	252.82	252.59	252.64	37803.0
2019-01-04 04:00:00	QQQ	ETF	151.68	152.37	151.6	152.36	162999.0
2019-01-04 04:30:00	QQQ	ETF	152.32	152.57	152.14	152.14	95967.0
2019-01-04 05:00:00	QQQ	ETF	152.14	152.31	152.06	152.22	31152.0
2019-01-04 05:30:00	QQQ	ETF	152.1	152.6	152.08	152.55	18132.0
2019-01-04 06:00:00	QQQ	ETF	152.55	152.81	152.26	152.71	39387.0
2019-01-04 06:30:00	QQQ	ETF	152.63	152.67	152.43	152.55	50511.0
2019-01-04 07:00:00	QQQ	ETF	152.53	152.57	152.2	152.3	94470.0
2019-01-04 07:30:00	QQQ	ETF	152.33	152.33	151.89	151.99	144300.0
2019-01-04 08:00:00	QQQ	ETF	152.5199	152.52	150.79	152.0	233612.0
2019-01-04 08:30:00	QQQ	ETF	152.1	152.28	151.4	151.92	700978.0
2019-01-04 09:00:00	QQQ	ETF	151.9	152.35	151.74	152.16	224165.0
2019-01-04 09:30:00	QQQ	ETF	152.18	153.41	151.74	153.33	7079310.0
2019-01-04 10:00:00	QQQ	ETF	153.33	154.75	152.67	154.75	6618702.0
2019-01-04 10:30:00	QQQ	ETF	154.74	155.21	154.4	155.2	5573191.0
2019-01-04 11:00:00	QQQ	ETF	155.19	155.74	154.99	155.39	4710184.0
2019-01-04 11:30:00	QQQ	ETF	155.37	155.9085	155.08	155.62	3592408.0
2019-01-04 12:00:00	QQQ	ETF	155.61	156.24	155.35	156.02	2580253.0
2019-01-04 12:30:00	QQQ	ETF	156.0	156.49	155.89	156.285	2868956.0

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

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