PREVIEW / etf_30min / 2018-11-14

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-11-14.parquet
  size:    493 KB
  rows:    17,100

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-14 04:00:00	SPY	ETF	271.1	271.85	270.85	271.44	52064.0
2018-11-14 04:30:00	SPY	ETF	271.42	271.7	271.34	271.68	29285.0
2018-11-14 05:00:00	SPY	ETF	271.68	272.21	271.48	272.21	29711.0
2018-11-14 05:30:00	SPY	ETF	272.16	272.62	271.9	272.56	19833.0
2018-11-14 06:00:00	SPY	ETF	272.52	272.57	272.06	272.21	7589.0
2018-11-14 06:30:00	SPY	ETF	272.21	272.55	271.81	271.94	65459.0
2018-11-14 07:00:00	SPY	ETF	271.94	272.77	271.94	272.66	173531.0
2018-11-14 07:30:00	SPY	ETF	272.67	272.9	272.44	272.51	131056.0
2018-11-14 08:00:00	SPY	ETF	272.26	273.05	271.0	272.97	300485.0
2018-11-14 08:30:00	SPY	ETF	273.0	274.1	272.86	273.85	811687.0
2018-11-14 09:00:00	SPY	ETF	273.9	274.35	273.63	274.18	543852.0
2018-11-14 09:30:00	SPY	ETF	274.16	274.61	273.6	274.04	7654985.0
2018-11-14 10:00:00	SPY	ETF	274.05	274.0869	272.54	272.85	5680250.0
2018-11-14 10:30:00	SPY	ETF	272.85	273.27	272.05	272.33	5654966.0
2018-11-14 11:00:00	SPY	ETF	272.33	272.34	271.05	271.33	9007923.0
2018-11-14 11:30:00	SPY	ETF	271.3301	271.46	270.35	271.38	7664278.0
2018-11-14 12:00:00	SPY	ETF	271.38	271.68	270.35	271.5	6100188.0
2018-11-14 12:30:00	SPY	ETF	271.5	274.16	270.05	270.24	6578284.0
2018-11-14 13:00:00	SPY	ETF	270.23	270.77	269.62	270.29	7190087.0
2018-11-14 13:30:00	SPY	ETF	270.27	270.461	269.0	269.51	6424825.0
2018-11-14 14:00:00	SPY	ETF	269.5	270.64	268.45	269.81	11491687.0
2018-11-14 14:30:00	SPY	ETF	269.77	271.5	269.475	271.36	8791938.0
2018-11-14 15:00:00	SPY	ETF	271.36	272.14	271.07	271.44	9328780.0
2018-11-14 15:30:00	SPY	ETF	271.45	271.63	269.53	270.14	16341443.0
2018-11-14 16:00:00	SPY	ETF	270.14	270.7927	269.38	269.79	11844706.0
2018-11-14 16:30:00	SPY	ETF	269.8	270.22	269.48	270.02	751501.0
2018-11-14 17:00:00	SPY	ETF	270.05	270.07	269.9	269.995	441166.0
2018-11-14 17:30:00	SPY	ETF	269.97	270.2	269.96	270.0	264051.0
2018-11-14 18:00:00	SPY	ETF	269.99	270.64	269.72	270.15	337537.0
2018-11-14 18:30:00	SPY	ETF	270.21	270.35	269.38	269.49	173250.0
2018-11-14 19:00:00	SPY	ETF	269.49	269.74	269.06	269.71	195305.0
2018-11-14 19:30:00	SPY	ETF	269.74	270.21	269.74	270.2	157959.0
2018-11-14 20:00:00	SPY	ETF	270.0538	270.2	270.0538	270.2	133906.0
2018-11-14 04:00:00	QQQ	ETF	165.09	165.45	165.04	165.45	21372.0
2018-11-14 04:30:00	QQQ	ETF	165.42	165.61	165.37	165.61	19351.0
2018-11-14 05:00:00	QQQ	ETF	165.63	166.3	165.6	166.22	23311.0
2018-11-14 05:30:00	QQQ	ETF	166.21	166.51	166.02	166.5	28448.0
2018-11-14 06:00:00	QQQ	ETF	166.52	166.52	166.11	166.21	14000.0
2018-11-14 06:30:00	QQQ	ETF	166.4	166.52	165.91	165.93	18166.0
2018-11-14 07:00:00	QQQ	ETF	166.04	166.64	166.04	166.52	57966.0
2018-11-14 07:30:00	QQQ	ETF	166.63	166.88	166.42	166.5	56128.0
2018-11-14 08:00:00	QQQ	ETF	166.3901	167.11	165.13	167.0	146729.0
2018-11-14 08:30:00	QQQ	ETF	167.05	167.96	167.05	167.69	533822.0
2018-11-14 09:00:00	QQQ	ETF	167.71	168.15	167.48	168.1	528242.0
2018-11-14 09:30:00	QQQ	ETF	168.1	168.7	167.41	167.8	6194669.0
2018-11-14 10:00:00	QQQ	ETF	167.76	167.84	166.315	166.81	4879797.0
2018-11-14 10:30:00	QQQ	ETF	166.81	167.26	166.0915	166.52	4479206.0
2018-11-14 11:00:00	QQQ	ETF	166.5	166.5	165.46	165.76	4565321.0
2018-11-14 11:30:00	QQQ	ETF	165.77	166.11	165.26	166.1	6302202.0
2018-11-14 12:00:00	QQQ	ETF	166.1	166.27	165.1	166.05	5621977.0

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

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