PREVIEW / etf_30min / 2018-08-02

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-08-02.parquet
  size:    467 KB
  rows:    16,026

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-08-02 04:00:00	SPY	ETF	280.0	280.01	279.75	279.81	44278.0
2018-08-02 04:30:00	SPY	ETF	279.81	279.88	279.47	279.51	37913.0
2018-08-02 05:00:00	SPY	ETF	279.43	279.5	279.11	279.14	27979.0
2018-08-02 05:30:00	SPY	ETF	279.17	279.17	278.85	279.09	62521.0
2018-08-02 06:00:00	SPY	ETF	279.1	279.18	278.83	279.03	60795.0
2018-08-02 06:30:00	SPY	ETF	279.01	279.1	278.81	279.1	97435.0
2018-08-02 07:00:00	SPY	ETF	279.15	279.34	278.99	279.32	231111.0
2018-08-02 07:30:00	SPY	ETF	279.3	279.33	279.2	279.32	86668.0
2018-08-02 08:00:00	SPY	ETF	279.1001	280.86	278.95	279.32	422867.0
2018-08-02 08:30:00	SPY	ETF	279.36	279.55	279.27	279.42	207519.0
2018-08-02 09:00:00	SPY	ETF	279.42	279.46	279.24	279.43	222005.0
2018-08-02 09:30:00	SPY	ETF	279.39	280.05	279.16	279.965	6530273.0
2018-08-02 10:00:00	SPY	ETF	279.97	280.7	279.94	280.55	4667616.0
2018-08-02 10:30:00	SPY	ETF	280.55	280.91	280.13	280.279	3346843.0
2018-08-02 11:00:00	SPY	ETF	280.28	280.87	280.23	280.75	2343322.0
2018-08-02 11:30:00	SPY	ETF	280.75	281.31	280.75	281.21	3365029.0
2018-08-02 12:00:00	SPY	ETF	281.22	281.89	281.01	281.74	2873419.0
2018-08-02 12:30:00	SPY	ETF	281.75	281.95	281.59	281.8	2319766.0
2018-08-02 13:00:00	SPY	ETF	281.8	282.14	281.8	282.06	2424037.0
2018-08-02 13:30:00	SPY	ETF	282.07	282.41	282.07	282.37	3279228.0
2018-08-02 14:00:00	SPY	ETF	282.36	282.5	282.12	282.14	3208678.0
2018-08-02 14:30:00	SPY	ETF	282.135	282.27	282.03	282.2337	2058931.0
2018-08-02 15:00:00	SPY	ETF	282.24	282.34	281.985	282.27	2943593.0
2018-08-02 15:30:00	SPY	ETF	282.26	282.58	282.22	282.34	9060032.0
2018-08-02 16:00:00	SPY	ETF	282.34	282.54	282.3118	282.41	11124674.0
2018-08-02 16:30:00	SPY	ETF	282.42	282.72	282.3021	282.67	626744.0
2018-08-02 17:00:00	SPY	ETF	282.67	282.7	282.61	282.62	13441.0
2018-08-02 17:30:00	SPY	ETF	282.64	282.71	282.64	282.71	13047.0
2018-08-02 18:00:00	SPY	ETF	282.64	282.67	282.56	282.59	15871.0
2018-08-02 18:30:00	SPY	ETF	282.56	282.69	282.52	282.61	10537.0
2018-08-02 19:00:00	SPY	ETF	282.55	282.58	282.54	282.55	3340.0
2018-08-02 19:30:00	SPY	ETF	282.55	282.55	282.49	282.52	21786.0
2018-08-02 04:00:00	QQQ	ETF	176.23	176.29	176.18	176.22	4621.0
2018-08-02 04:30:00	QQQ	ETF	176.22	176.24	176.02	176.08	23200.0
2018-08-02 05:00:00	QQQ	ETF	176.03	176.03	175.74	175.74	31565.0
2018-08-02 05:30:00	QQQ	ETF	175.81	175.81	175.56	175.74	30966.0
2018-08-02 06:00:00	QQQ	ETF	175.74	175.82	175.6	175.77	33489.0
2018-08-02 06:30:00	QQQ	ETF	175.71	175.76	175.62	175.72	23485.0
2018-08-02 07:00:00	QQQ	ETF	175.77	175.83	175.67	175.79	165690.0
2018-08-02 07:30:00	QQQ	ETF	175.81	176.17	175.71	175.73	128683.0
2018-08-02 08:00:00	QQQ	ETF	175.79	176.7	175.58	175.76	168274.0
2018-08-02 08:30:00	QQQ	ETF	175.8	175.97	175.78	175.84	123123.0
2018-08-02 09:00:00	QQQ	ETF	175.83	175.9	175.68	175.87	246419.0
2018-08-02 09:30:00	QQQ	ETF	175.87	176.83	175.79	176.7367	4540188.0
2018-08-02 10:00:00	QQQ	ETF	176.74	177.57	176.735	177.49	3448698.0
2018-08-02 10:30:00	QQQ	ETF	177.485	177.88	177.36	177.395	3113359.0
2018-08-02 11:00:00	QQQ	ETF	177.3975	177.99	177.18	177.92	2061269.0
2018-08-02 11:30:00	QQQ	ETF	177.93	178.53	177.93	178.275	3036137.0
2018-08-02 12:00:00	QQQ	ETF	178.29	178.97	178.09	178.8884	2212689.0
2018-08-02 12:30:00	QQQ	ETF	178.87	179.02	178.72	178.8	1843317.0

> showing 50 of 16,026 rows — these rows as CSV

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