PREVIEW / etf_30min / 2018-11-15

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-11-15.parquet
  size:    494 KB
  rows:    17,280

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-11-15 04:00:00	SPY	ETF	270.23	270.55	269.93	270.17	22673.0
2018-11-15 04:30:00	SPY	ETF	270.13	270.14	269.7	269.77	37054.0
2018-11-15 05:00:00	SPY	ETF	269.77	270.05	269.32	269.98	81312.0
2018-11-15 05:30:00	SPY	ETF	269.98	270.56	269.83	270.5	73212.0
2018-11-15 06:00:00	SPY	ETF	270.52	270.89	270.45	270.55	59330.0
2018-11-15 06:30:00	SPY	ETF	270.51	270.76	270.3	270.6	80280.0
2018-11-15 07:00:00	SPY	ETF	270.57	270.83	270.4	270.75	287688.0
2018-11-15 07:30:00	SPY	ETF	270.7	270.75	270.05	270.06	223278.0
2018-11-15 08:00:00	SPY	ETF	270.06	270.77	269.25	269.8	490603.0
2018-11-15 08:30:00	SPY	ETF	269.88	270.04	269.14	269.55	410422.0
2018-11-15 09:00:00	SPY	ETF	269.45	269.71	268.09	268.75	935213.0
2018-11-15 09:30:00	SPY	ETF	268.78	269.68	267.66	268.59	12097543.0
2018-11-15 10:00:00	SPY	ETF	268.61	269.24	268.08	268.23	8750721.0
2018-11-15 10:30:00	SPY	ETF	268.23	268.86	267.0102	268.54	10051833.0
2018-11-15 11:00:00	SPY	ETF	268.52	270.15	268.31	269.86	7790576.0
2018-11-15 11:30:00	SPY	ETF	269.855	270.77	269.73	270.415	6995753.0
2018-11-15 12:00:00	SPY	ETF	270.419	270.95	269.82	270.5299	7096989.0
2018-11-15 12:30:00	SPY	ETF	270.53	270.87	269.47	269.6836	4292066.0
2018-11-15 13:00:00	SPY	ETF	269.68	271.84	269.06	271.81	9315139.0
2018-11-15 13:30:00	SPY	ETF	271.8199	272.71	271.52	272.4525	9512693.0
2018-11-15 14:00:00	SPY	ETF	272.4515	273.15	271.96	273.01	7319290.0
2018-11-15 14:30:00	SPY	ETF	273.02	273.54	272.42	272.66	6603889.0
2018-11-15 15:00:00	SPY	ETF	272.66	273.04	271.03	271.75	14954371.0
2018-11-15 15:30:00	SPY	ETF	271.7425	273.09	271.72	273.04	13352756.0
2018-11-15 16:00:00	SPY	ETF	273.03	273.48	272.65	273.2	7867762.0
2018-11-15 16:30:00	SPY	ETF	273.21	273.4	272.77	273.22	3252118.0
2018-11-15 17:00:00	SPY	ETF	273.13	273.2	272.95	273.01	1935041.0
2018-11-15 17:30:00	SPY	ETF	273.01	273.05	272.88	272.96	82334.0
2018-11-15 18:00:00	SPY	ETF	272.97	273.01	272.5	272.69	141430.0
2018-11-15 18:30:00	SPY	ETF	272.66	272.74	272.39	272.52	89316.0
2018-11-15 19:00:00	SPY	ETF	272.42	272.92	272.41	272.78	48294.0
2018-11-15 19:30:00	SPY	ETF	272.72	272.92	272.55	272.73	26121.0
2018-11-15 04:00:00	QQQ	ETF	166.0	166.21	165.54	165.6	51180.0
2018-11-15 04:30:00	QQQ	ETF	165.59	165.64	165.28	165.35	35024.0
2018-11-15 05:00:00	QQQ	ETF	165.21	165.62	165.01	165.53	43932.0
2018-11-15 05:30:00	QQQ	ETF	165.52	165.96	165.44	165.94	68269.0
2018-11-15 06:00:00	QQQ	ETF	166.0	166.23	165.88	166.0	63148.0
2018-11-15 06:30:00	QQQ	ETF	165.94	166.05	165.7	165.95	53235.0
2018-11-15 07:00:00	QQQ	ETF	165.95	166.19	165.8	166.0	86202.0
2018-11-15 07:30:00	QQQ	ETF	166.05	166.1	165.53	165.54	148250.0
2018-11-15 08:00:00	QQQ	ETF	165.915	166.68	164.99	165.3	238646.0
2018-11-15 08:30:00	QQQ	ETF	165.3	165.49	164.83	165.11	210242.0
2018-11-15 09:00:00	QQQ	ETF	165.1	165.27	164.05	164.83	710188.0
2018-11-15 09:30:00	QQQ	ETF	164.84	165.88	164.17	164.64	6232501.0
2018-11-15 10:00:00	QQQ	ETF	164.65	165.1	164.2	164.26	3504098.0
2018-11-15 10:30:00	QQQ	ETF	164.2699	165.0883	163.46	164.76	3952322.0
2018-11-15 11:00:00	QQQ	ETF	164.76	165.9	164.52	165.675	4239869.0
2018-11-15 11:30:00	QQQ	ETF	165.68	166.22	165.57	165.89	4124545.0
2018-11-15 12:00:00	QQQ	ETF	165.9	166.2	165.39	166.01	2504264.0
2018-11-15 12:30:00	QQQ	ETF	166.02	166.365	165.31	165.52	1801421.0

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

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