PREVIEW / etf_30min / 2018-01-16

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-01-16.parquet
  size:    514 KB
  rows:    17,778

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-01-16 04:00:00	SPY	ETF	279.0	279.32	279.0	279.32	7932.0
2018-01-16 04:30:00	SPY	ETF	279.34	279.5	279.34	279.49	15815.0
2018-01-16 05:00:00	SPY	ETF	279.44	279.54	279.44	279.53	24400.0
2018-01-16 05:30:00	SPY	ETF	279.54	279.59	279.52	279.59	18491.0
2018-01-16 06:00:00	SPY	ETF	279.59	279.65	279.41	279.48	16385.0
2018-01-16 06:30:00	SPY	ETF	279.49	279.5	279.4	279.4	15975.0
2018-01-16 07:00:00	SPY	ETF	279.34	279.37	279.15	279.18	99934.0
2018-01-16 07:30:00	SPY	ETF	279.18	279.35	279.16	279.3	213415.0
2018-01-16 08:00:00	SPY	ETF	279.31	279.42	279.15	279.36	283223.0
2018-01-16 08:30:00	SPY	ETF	279.38	279.48	279.25	279.45	155158.0
2018-01-16 09:00:00	SPY	ETF	279.44	279.46	279.26	279.35	622567.0
2018-01-16 09:30:00	SPY	ETF	279.35	280.09	279.28	279.99	8997831.0
2018-01-16 10:00:00	SPY	ETF	280.0	280.01	279.54	279.62	4591326.0
2018-01-16 10:30:00	SPY	ETF	279.63	279.645	278.67	278.755	6511903.0
2018-01-16 11:00:00	SPY	ETF	278.76	278.94	278.335	278.93	5224679.0
2018-01-16 11:30:00	SPY	ETF	278.92	279.03	278.31	278.479	4286269.0
2018-01-16 12:00:00	SPY	ETF	278.48	278.89	278.47	278.6	2943290.0
2018-01-16 12:30:00	SPY	ETF	278.61	278.6366	278.25	278.3131	2445237.0
2018-01-16 13:00:00	SPY	ETF	278.31	278.535	278.15	278.35	6211316.0
2018-01-16 13:30:00	SPY	ETF	278.35	278.39	277.61	277.69	9434519.0
2018-01-16 14:00:00	SPY	ETF	277.7	277.79	276.9	276.965	7527770.0
2018-01-16 14:30:00	SPY	ETF	276.965	277.23	276.18	276.76	9794473.0
2018-01-16 15:00:00	SPY	ETF	276.77	277.55	276.76	277.53	7572620.0
2018-01-16 15:30:00	SPY	ETF	277.53	277.59	276.86	276.96	18243513.0
2018-01-16 16:00:00	SPY	ETF	276.93	277.52	276.93	277.51	8972112.0
2018-01-16 16:30:00	SPY	ETF	277.51	278.7872	276.97	277.47	1084957.0
2018-01-16 17:00:00	SPY	ETF	277.48	277.5	277.3	277.4	197958.0
2018-01-16 17:30:00	SPY	ETF	277.38	277.41	277.32	277.41	68234.0
2018-01-16 18:00:00	SPY	ETF	277.4	277.48	277.12	277.16	137808.0
2018-01-16 18:30:00	SPY	ETF	277.2	277.28	277.06	277.28	35659.0
2018-01-16 19:00:00	SPY	ETF	277.28	277.52	277.28	277.42	47779.0
2018-01-16 19:30:00	SPY	ETF	277.44	277.44	277.28	277.44	27991.0
2018-01-16 04:00:00	QQQ	ETF	165.2	165.38	165.1	165.38	18222.0
2018-01-16 04:30:00	QQQ	ETF	165.47	165.48	165.41	165.48	14500.0
2018-01-16 05:00:00	QQQ	ETF	165.49	165.55	165.46	165.55	16100.0
2018-01-16 05:30:00	QQQ	ETF	165.59	165.71	165.59	165.69	9000.0
2018-01-16 06:00:00	QQQ	ETF	165.7	165.74	165.6	165.68	16300.0
2018-01-16 06:30:00	QQQ	ETF	165.68	165.77	165.61	165.63	21550.0
2018-01-16 07:00:00	QQQ	ETF	165.61	165.62	165.5	165.55	27169.0
2018-01-16 07:30:00	QQQ	ETF	165.59	165.59	165.5	165.57	42050.0
2018-01-16 08:00:00	QQQ	ETF	165.6	165.68	165.5	165.66	55167.0
2018-01-16 08:30:00	QQQ	ETF	165.67	165.68	165.52	165.59	39483.0
2018-01-16 09:00:00	QQQ	ETF	165.59	165.61	165.45	165.56	407085.0
2018-01-16 09:30:00	QQQ	ETF	165.55	166.415	165.54	166.23	4004940.0
2018-01-16 10:00:00	QQQ	ETF	166.23	166.3161	165.89	166.035	2055377.0
2018-01-16 10:30:00	QQQ	ETF	166.04	166.06	165.48	165.63	2302052.0
2018-01-16 11:00:00	QQQ	ETF	165.62	165.695	165.12	165.4901	2961720.0
2018-01-16 11:30:00	QQQ	ETF	165.5	165.64	164.98	165.03	2390828.0
2018-01-16 12:00:00	QQQ	ETF	165.04	165.45	165.04	165.16	1173351.0
2018-01-16 12:30:00	QQQ	ETF	165.1653	165.19	164.75	164.8661	1083276.0

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

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