PREVIEW / etf_30min / 2019-12-13

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-12-13.parquet
  size:    530 KB
  rows:    18,521

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
2019-12-13 04:00:00	SPY	ETF	318.36	318.53	318.03	318.5	25826.0
2019-12-13 04:30:00	SPY	ETF	318.33	318.44	318.28	318.44	7464.0
2019-12-13 05:00:00	SPY	ETF	318.5	318.63	318.5	318.63	3050.0
2019-12-13 05:30:00	SPY	ETF	318.7	318.79	318.66	318.75	14807.0
2019-12-13 06:00:00	SPY	ETF	318.6	318.6	318.37	318.37	26025.0
2019-12-13 06:30:00	SPY	ETF	318.4	318.41	318.26	318.36	4058.0
2019-12-13 07:00:00	SPY	ETF	318.38	318.44	318.06	318.08	117867.0
2019-12-13 07:30:00	SPY	ETF	318.1	318.35	316.57	317.39	722377.0
2019-12-13 08:00:00	SPY	ETF	318.3299	318.76	317.04	317.83	1056077.0
2019-12-13 08:30:00	SPY	ETF	317.76	318.28	317.5456	317.96	215559.0
2019-12-13 09:00:00	SPY	ETF	317.99	317.99	316.31	316.83	2319826.0
2019-12-13 09:30:00	SPY	ETF	316.87	317.49	316.35	317.305	6985096.0
2019-12-13 10:00:00	SPY	ETF	317.305	318.67	317.0	317.67	14283471.0
2019-12-13 10:30:00	SPY	ETF	317.67	317.68	316.51	316.55	10427573.0
2019-12-13 11:00:00	SPY	ETF	316.54	317.18	316.02	316.11	5757552.0
2019-12-13 11:30:00	SPY	ETF	316.1	317.15	316.05	317.12	2791623.0
2019-12-13 12:00:00	SPY	ETF	317.11	317.33	316.94	317.28	3626998.0
2019-12-13 12:30:00	SPY	ETF	317.28	317.51	317.11	317.49	2675375.0
2019-12-13 13:00:00	SPY	ETF	317.49	317.56	317.3	317.3	3291253.0
2019-12-13 13:30:00	SPY	ETF	317.3	317.49	317.19	317.425	4052608.0
2019-12-13 14:00:00	SPY	ETF	317.43	317.5	317.24	317.275	1829263.0
2019-12-13 14:30:00	SPY	ETF	317.28	317.38	317.08	317.3	2910079.0
2019-12-13 15:00:00	SPY	ETF	317.3	317.39	317.17	317.1843	3029976.0
2019-12-13 15:30:00	SPY	ETF	317.19	317.5	317.15	317.28	7020679.0
2019-12-13 16:00:00	SPY	ETF	317.27	317.52	317.26	317.41	4592028.0
2019-12-13 16:30:00	SPY	ETF	317.41	317.52	317.32	317.49	2714241.0
2019-12-13 17:00:00	SPY	ETF	317.48	317.54	317.38	317.42	76966.0
2019-12-13 17:30:00	SPY	ETF	317.41	317.45	317.32	317.34	195667.0
2019-12-13 18:00:00	SPY	ETF	317.4	317.4	317.27	317.32	16786.0
2019-12-13 18:30:00	SPY	ETF	317.32	317.32	317.32	317.32	6027.0
2019-12-13 19:00:00	SPY	ETF	317.32	317.32	317.23	317.32	13243.0
2019-12-13 19:30:00	SPY	ETF	317.32	317.32	317.25	317.25	6696.0
2019-12-13 04:00:00	QQQ	ETF	207.66	207.71	207.55	207.66	22286.0
2019-12-13 04:30:00	QQQ	ETF	207.63	207.64	207.55	207.62	4801.0
2019-12-13 05:00:00	QQQ	ETF	207.69	207.82	207.66	207.82	12400.0
2019-12-13 05:30:00	QQQ	ETF	207.85	207.94	207.83	207.9	16248.0
2019-12-13 06:00:00	QQQ	ETF	207.87	207.89	207.65	207.68	11658.0
2019-12-13 06:30:00	QQQ	ETF	207.67	207.7	207.55	207.62	11317.0
2019-12-13 07:00:00	QQQ	ETF	207.63	207.64	207.31	207.37	62479.0
2019-12-13 07:30:00	QQQ	ETF	207.35	207.56	206.3	206.91	230336.0
2019-12-13 08:00:00	QQQ	ETF	206.91	207.75	206.74	207.22	141021.0
2019-12-13 08:30:00	QQQ	ETF	207.16	207.52	207.15	207.3	133495.0
2019-12-13 09:00:00	QQQ	ETF	207.33	207.33	205.86	206.3	895293.0
2019-12-13 09:30:00	QQQ	ETF	206.38	207.0	205.96	206.8996	3200071.0
2019-12-13 10:00:00	QQQ	ETF	206.87	207.91	206.69	207.405	5856498.0
2019-12-13 10:30:00	QQQ	ETF	207.4	207.5	206.54	206.69	4826843.0
2019-12-13 11:00:00	QQQ	ETF	206.6971	207.2	206.29	206.36	1851903.0
2019-12-13 11:30:00	QQQ	ETF	206.36	207.12	206.33	207.094	1022817.0
2019-12-13 12:00:00	QQQ	ETF	207.09	207.32	207.07	207.28	952149.0
2019-12-13 12:30:00	QQQ	ETF	207.29	207.51	207.23	207.49	804655.0

> showing 50 of 18,521 rows — these rows as CSV

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