PREVIEW / etf_30min / 2018-01-12

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-01-12.parquet
  size:    497 KB
  rows:    17,050

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-12 04:00:00	SPY	ETF	276.76	276.92	276.45	276.87	10024.0
2018-01-12 04:30:00	SPY	ETF	276.84	276.88	276.79	276.85	5200.0
2018-01-12 05:00:00	SPY	ETF	276.75	276.8	276.71	276.74	6700.0
2018-01-12 05:30:00	SPY	ETF	276.84	276.88	276.81	276.83	2100.0
2018-01-12 06:00:00	SPY	ETF	276.85	276.9	276.82	276.82	16072.0
2018-01-12 06:30:00	SPY	ETF	276.84	276.88	276.78	276.8	51300.0
2018-01-12 07:00:00	SPY	ETF	276.84	276.91	276.72	276.77	212482.0
2018-01-12 07:30:00	SPY	ETF	276.74	276.8	276.68	276.68	63467.0
2018-01-12 08:00:00	SPY	ETF	276.68	276.9	276.58	276.78	199739.0
2018-01-12 08:30:00	SPY	ETF	276.79	276.79	275.96	276.2	822779.0
2018-01-12 09:00:00	SPY	ETF	276.23	276.69	276.15	276.41	543175.0
2018-01-12 09:30:00	SPY	ETF	276.42	277.03	276.27	277.03	5404297.0
2018-01-12 10:00:00	SPY	ETF	277.025	277.19	276.829	277.165	3771953.0
2018-01-12 10:30:00	SPY	ETF	277.165	277.81	277.11	277.6297	6262154.0
2018-01-12 11:00:00	SPY	ETF	277.63	277.68	277.15	277.3886	4445456.0
2018-01-12 11:30:00	SPY	ETF	277.39	277.63	277.32	277.63	1987432.0
2018-01-12 12:00:00	SPY	ETF	277.63	277.71	277.47	277.49	3117374.0
2018-01-12 12:30:00	SPY	ETF	277.495	277.67	277.36	277.66	2826085.0
2018-01-12 13:00:00	SPY	ETF	277.66	277.72	277.44	277.55	3163444.0
2018-01-12 13:30:00	SPY	ETF	277.545	277.82	277.51	277.715	2561894.0
2018-01-12 14:00:00	SPY	ETF	277.715	277.89	277.655	277.875	6242219.0
2018-01-12 14:30:00	SPY	ETF	277.88	277.92	277.53	277.755	8088604.0
2018-01-12 15:00:00	SPY	ETF	277.755	277.895	277.39	277.64	5496082.0
2018-01-12 15:30:00	SPY	ETF	277.64	278.11	277.63	277.91	16483218.0
2018-01-12 16:00:00	SPY	ETF	277.91	278.21	277.85	277.9916	15726186.0
2018-01-12 16:30:00	SPY	ETF	278.18	278.26	278.11	278.18	352533.0
2018-01-12 17:00:00	SPY	ETF	277.92	278.2	277.92	277.94	344976.0
2018-01-12 17:30:00	SPY	ETF	278.0	278.02	277.92	277.97	294825.0
2018-01-12 18:00:00	SPY	ETF	277.98	277.98	277.54	277.89	64413.0
2018-01-12 18:30:00	SPY	ETF	277.89	277.94	277.88	277.93	12309.0
2018-01-12 19:00:00	SPY	ETF	277.93	277.99	277.93	277.98	14335.0
2018-01-12 19:30:00	SPY	ETF	277.94	278.04	277.94	278.01	8773.0
2018-01-12 04:00:00	QQQ	ETF	163.86	163.89	163.82	163.83	20300.0
2018-01-12 04:30:00	QQQ	ETF	163.78	163.8	163.76	163.77	7100.0
2018-01-12 05:00:00	QQQ	ETF	163.76	163.81	163.76	163.78	24841.0
2018-01-12 05:30:00	QQQ	ETF	163.8	163.85	163.72	163.76	36072.0
2018-01-12 06:00:00	QQQ	ETF	163.74	163.76	163.72	163.72	7500.0
2018-01-12 06:30:00	QQQ	ETF	163.73	163.74	163.68	163.7	23300.0
2018-01-12 07:00:00	QQQ	ETF	163.72	163.74	163.67	163.71	87900.0
2018-01-12 07:30:00	QQQ	ETF	163.72	163.72	163.67	163.71	54650.0
2018-01-12 08:00:00	QQQ	ETF	163.74	163.89	163.68	163.85	253278.0
2018-01-12 08:30:00	QQQ	ETF	163.78	163.78	162.98	163.06	554510.0
2018-01-12 09:00:00	QQQ	ETF	163.06	163.35	163.0	163.09	445457.0
2018-01-12 09:30:00	QQQ	ETF	163.03	163.545	162.94	163.535	3276566.0
2018-01-12 10:00:00	QQQ	ETF	163.53	163.85	163.485	163.845	1836614.0
2018-01-12 10:30:00	QQQ	ETF	163.845	164.29	163.735	164.2	1639443.0
2018-01-12 11:00:00	QQQ	ETF	164.201	164.33	164.03	164.145	1128055.0
2018-01-12 11:30:00	QQQ	ETF	164.145	164.28	164.075	164.25	795450.0
2018-01-12 12:00:00	QQQ	ETF	164.26	164.29	164.13	164.2	948323.0
2018-01-12 12:30:00	QQQ	ETF	164.2	164.5	164.14	164.48	795804.0

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

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