PREVIEW / etf_30min / 2018-08-13

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-08-13.parquet
  size:    471 KB
  rows:    16,307

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-13 04:00:00	SPY	ETF	282.24	283.15	282.14	282.62	33452.0
2018-08-13 04:30:00	SPY	ETF	282.51	282.66	282.49	282.61	3510.0
2018-08-13 05:00:00	SPY	ETF	282.75	282.75	282.56	282.65	4885.0
2018-08-13 05:30:00	SPY	ETF	282.73	282.84	282.48	282.48	11451.0
2018-08-13 06:00:00	SPY	ETF	282.51	282.66	282.39	282.65	9500.0
2018-08-13 06:30:00	SPY	ETF	282.64	282.79	282.58	282.58	24688.0
2018-08-13 07:00:00	SPY	ETF	282.58	282.79	282.58	282.68	54035.0
2018-08-13 07:30:00	SPY	ETF	282.65	283.4	282.64	283.3	165381.0
2018-08-13 08:00:00	SPY	ETF	282.7201	283.58	282.03	283.56	288450.0
2018-08-13 08:30:00	SPY	ETF	283.57	283.58	283.26	283.33	313154.0
2018-08-13 09:00:00	SPY	ETF	283.31	283.48	283.24	283.47	207515.0
2018-08-13 09:30:00	SPY	ETF	283.47	283.95	283.35	283.8985	4725716.0
2018-08-13 10:00:00	SPY	ETF	283.9	284.16	283.77	283.975	3050840.0
2018-08-13 10:30:00	SPY	ETF	283.98	284.14	283.72	283.7838	2293866.0
2018-08-13 11:00:00	SPY	ETF	283.7875	283.91	283.01	283.03	4489801.0
2018-08-13 11:30:00	SPY	ETF	283.03	283.13	282.42	282.42	3686699.0
2018-08-13 12:00:00	SPY	ETF	282.42	282.745	282.07	282.275	3510036.0
2018-08-13 12:30:00	SPY	ETF	282.27	282.48	282.08	282.17	3719616.0
2018-08-13 13:00:00	SPY	ETF	282.16	282.55	281.77	282.52	4169217.0
2018-08-13 13:30:00	SPY	ETF	282.53	282.78	282.3016	282.45	2617204.0
2018-08-13 14:00:00	SPY	ETF	282.46	283.11	282.46	283.06	3253767.0
2018-08-13 14:30:00	SPY	ETF	283.07	283.13	282.39	282.49	3558284.0
2018-08-13 15:00:00	SPY	ETF	282.49	282.79	282.26	282.36	3979016.0
2018-08-13 15:30:00	SPY	ETF	282.37	282.54	281.94	282.05	10416508.0
2018-08-13 16:00:00	SPY	ETF	282.06	282.44	282.0125	282.4	6995943.0
2018-08-13 16:30:00	SPY	ETF	282.39	282.48	282.1	282.35	1144399.0
2018-08-13 17:00:00	SPY	ETF	282.43	282.44	282.33	282.34	60578.0
2018-08-13 17:30:00	SPY	ETF	282.35	282.4	282.31	282.4	56409.0
2018-08-13 18:00:00	SPY	ETF	282.41	282.61	282.37	282.61	54426.0
2018-08-13 18:30:00	SPY	ETF	282.59	282.65	282.56	282.61	7600.0
2018-08-13 19:00:00	SPY	ETF	282.57	282.58	282.5	282.58	10629.0
2018-08-13 19:30:00	SPY	ETF	282.58	282.63	282.49	282.53	20607.0
2018-08-13 04:00:00	QQQ	ETF	179.94	180.06	179.75	180.05	8759.0
2018-08-13 04:30:00	QQQ	ETF	180.04	180.12	179.98	180.1	3043.0
2018-08-13 05:00:00	QQQ	ETF	180.22	180.22	180.03	180.1	3600.0
2018-08-13 05:30:00	QQQ	ETF	180.26	180.26	180.1	180.1	1400.0
2018-08-13 06:00:00	QQQ	ETF	180.07	180.12	180.03	180.12	7400.0
2018-08-13 06:30:00	QQQ	ETF	180.16	180.3	180.12	180.14	17500.0
2018-08-13 07:00:00	QQQ	ETF	180.12	180.35	180.12	180.25	10597.0
2018-08-13 07:30:00	QQQ	ETF	180.23	180.92	180.23	180.86	71453.0
2018-08-13 08:00:00	QQQ	ETF	180.86	181.08	179.63	181.06	256100.0
2018-08-13 08:30:00	QQQ	ETF	181.07	181.13	180.87	180.88	122764.0
2018-08-13 09:00:00	QQQ	ETF	180.85	180.96	180.8	180.82	148407.0
2018-08-13 09:30:00	QQQ	ETF	180.85	181.5627	180.76	181.5201	2700065.0
2018-08-13 10:00:00	QQQ	ETF	181.52	182.01	181.43	181.84	2176042.0
2018-08-13 10:30:00	QQQ	ETF	181.85	181.9891	181.66	181.69	1122151.0
2018-08-13 11:00:00	QQQ	ETF	181.7	181.77	180.88	180.89	1577694.0
2018-08-13 11:30:00	QQQ	ETF	180.9	181.0436	180.57	180.62	1846596.0
2018-08-13 12:00:00	QQQ	ETF	180.61	181.0	180.37	180.518	1553275.0
2018-08-13 12:30:00	QQQ	ETF	180.48	180.8	180.3999	180.59	1608019.0

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

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