PREVIEW / etf_30min / 2018-06-06

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-06-06.parquet
  size:    474 KB
  rows:    16,189

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-06-06 04:00:00	SPY	ETF	275.65	275.87	275.65	275.75	9616.0
2018-06-06 04:30:00	SPY	ETF	275.78	275.88	275.72	275.72	4543.0
2018-06-06 05:00:00	SPY	ETF	275.73	276.06	275.73	276.0	9096.0
2018-06-06 05:30:00	SPY	ETF	275.99	276.04	275.88	276.04	21882.0
2018-06-06 06:00:00	SPY	ETF	276.02	276.02	275.87	275.95	13404.0
2018-06-06 06:30:00	SPY	ETF	275.9	276.02	275.85	275.97	36005.0
2018-06-06 07:00:00	SPY	ETF	275.96	276.04	275.77	276.02	60258.0
2018-06-06 07:30:00	SPY	ETF	276.01	276.04	275.95	276.02	56274.0
2018-06-06 08:00:00	SPY	ETF	275.9399	276.04	275.9	275.97	139337.0
2018-06-06 08:30:00	SPY	ETF	275.96	276.02	275.8	275.8	120377.0
2018-06-06 09:00:00	SPY	ETF	275.78	275.82	275.65	275.8	1245701.0
2018-06-06 09:30:00	SPY	ETF	275.79	275.98	275.331	275.39	5091010.0
2018-06-06 10:00:00	SPY	ETF	275.4	275.56	275.13	275.46	3213162.0
2018-06-06 10:30:00	SPY	ETF	275.47	275.62	275.09	275.6	5314918.0
2018-06-06 11:00:00	SPY	ETF	275.61	276.16	275.6	276.14	3938880.0
2018-06-06 11:30:00	SPY	ETF	276.14	276.44	276.11	276.42	2762959.0
2018-06-06 12:00:00	SPY	ETF	276.42	276.46	276.19	276.3276	2535310.0
2018-06-06 12:30:00	SPY	ETF	276.32	276.43	276.18	276.33	1471743.0
2018-06-06 13:00:00	SPY	ETF	276.33	276.48	276.11	276.395	1967531.0
2018-06-06 13:30:00	SPY	ETF	276.39	276.44	276.255	276.32	2023735.0
2018-06-06 14:00:00	SPY	ETF	276.32	276.63	276.32	276.63	1616299.0
2018-06-06 14:30:00	SPY	ETF	276.62	277.14	276.56	277.0	4648738.0
2018-06-06 15:00:00	SPY	ETF	277.0	277.12	276.84	277.0048	4379573.0
2018-06-06 15:30:00	SPY	ETF	277.0	277.52	276.89	277.5	9941270.0
2018-06-06 16:00:00	SPY	ETF	277.5	277.55	277.39	277.5	7958805.0
2018-06-06 16:30:00	SPY	ETF	277.5	277.72	275.5	277.62	1491551.0
2018-06-06 17:00:00	SPY	ETF	277.64	277.7	277.6	277.66	231605.0
2018-06-06 17:30:00	SPY	ETF	277.66	277.7	277.63	277.64	62166.0
2018-06-06 18:00:00	SPY	ETF	277.64	277.69	277.54	277.58	110857.0
2018-06-06 18:30:00	SPY	ETF	277.54	277.58	277.48	277.5	24183.0
2018-06-06 19:00:00	SPY	ETF	277.48	277.49	277.34	277.36	25850.0
2018-06-06 19:30:00	SPY	ETF	277.38	277.49	277.36	277.48	18339.0
2018-06-06 04:00:00	QQQ	ETF	175.22	175.22	175.12	175.19	1300.0
2018-06-06 04:30:00	QQQ	ETF	175.23	175.24	175.2	175.21	2400.0
2018-06-06 05:00:00	QQQ	ETF	175.32	175.4	175.32	175.4	2400.0
2018-06-06 05:30:00	QQQ	ETF	175.29	175.38	175.29	175.38	12500.0
2018-06-06 06:00:00	QQQ	ETF	175.3	175.33	175.23	175.3	6800.0
2018-06-06 06:30:00	QQQ	ETF	175.26	175.31	175.25	175.28	7150.0
2018-06-06 07:00:00	QQQ	ETF	175.26	175.3	175.18	175.29	16889.0
2018-06-06 07:30:00	QQQ	ETF	175.31	175.31	175.2	175.25	18227.0
2018-06-06 08:00:00	QQQ	ETF	175.25	175.28	174.84	175.24	40755.0
2018-06-06 08:30:00	QQQ	ETF	175.26	175.26	175.02	175.02	111448.0
2018-06-06 09:00:00	QQQ	ETF	175.01	175.1	174.9	175.04	170010.0
2018-06-06 09:30:00	QQQ	ETF	175.04	175.22	174.54	174.57	2201350.0
2018-06-06 10:00:00	QQQ	ETF	174.6	174.68	174.22	174.5	1682341.0
2018-06-06 10:30:00	QQQ	ETF	174.5	174.65	174.14	174.63	1354804.0
2018-06-06 11:00:00	QQQ	ETF	174.63	175.16	174.62	175.15	1656774.0
2018-06-06 11:30:00	QQQ	ETF	175.15	175.29	175.04	175.27	1476134.0
2018-06-06 12:00:00	QQQ	ETF	175.27	175.345	174.93	175.02	1180167.0
2018-06-06 12:30:00	QQQ	ETF	175.01	175.1	174.92	175.09	823078.0

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

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