PREVIEW / etf_30min / 2019-05-23

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-05-23.parquet
  size:    512 KB
  rows:    17,884

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-05-23 04:00:00	SPY	ETF	284.2	284.2	283.51	283.66	13125.0
2019-05-23 04:30:00	SPY	ETF	283.56	283.71	283.4	283.7	14203.0
2019-05-23 05:00:00	SPY	ETF	283.6	283.71	283.09	283.09	7670.0
2019-05-23 05:30:00	SPY	ETF	283.19	283.19	282.77	282.9	35663.0
2019-05-23 06:00:00	SPY	ETF	282.85	283.05	282.6	283.05	36571.0
2019-05-23 06:30:00	SPY	ETF	283.0	283.2	282.95	282.95	99078.0
2019-05-23 07:00:00	SPY	ETF	283.08	283.43	283.03	283.37	141124.0
2019-05-23 07:30:00	SPY	ETF	283.38	283.6	283.17	283.34	210317.0
2019-05-23 08:00:00	SPY	ETF	283.26	285.63	282.99	283.1	385045.0
2019-05-23 08:30:00	SPY	ETF	283.08	283.7	283.07	283.24	455660.0
2019-05-23 09:00:00	SPY	ETF	283.29	283.3	282.9	283.23	320197.0
2019-05-23 09:30:00	SPY	ETF	283.16	283.21	281.69	282.02	9769245.0
2019-05-23 10:00:00	SPY	ETF	282.02	282.54	281.53	282.22	7374891.0
2019-05-23 10:30:00	SPY	ETF	282.22	282.88	282.09	282.635	5058201.0
2019-05-23 11:00:00	SPY	ETF	282.64	282.67	281.84	282.14	3991331.0
2019-05-23 11:30:00	SPY	ETF	282.15	282.33	281.24	281.29	4586975.0
2019-05-23 12:00:00	SPY	ETF	281.3	281.92	281.145	281.44	4791392.0
2019-05-23 12:30:00	SPY	ETF	281.44	281.585	280.86	280.93	4391695.0
2019-05-23 13:00:00	SPY	ETF	280.92	281.48	280.72	281.27	4663882.0
2019-05-23 13:30:00	SPY	ETF	281.27	281.54	280.99	281.21	3504090.0
2019-05-23 14:00:00	SPY	ETF	281.2	281.43	280.79	280.88	4560349.0
2019-05-23 14:30:00	SPY	ETF	280.88	281.21	280.63	280.9	5236011.0
2019-05-23 15:00:00	SPY	ETF	280.8991	282.35	280.57	282.06	9075154.0
2019-05-23 15:30:00	SPY	ETF	282.07	282.39	281.3	282.27	15588135.0
2019-05-23 16:00:00	SPY	ETF	282.25	282.5	281.89	282.36	11941523.0
2019-05-23 16:30:00	SPY	ETF	282.29	282.29	281.94	282.08	613072.0
2019-05-23 17:00:00	SPY	ETF	282.06	282.2	282.06	282.15	106507.0
2019-05-23 17:30:00	SPY	ETF	282.1399	282.14	282.12	282.13	11617.0
2019-05-23 18:00:00	SPY	ETF	282.15	282.47	282.15	282.42	138421.0
2019-05-23 18:30:00	SPY	ETF	282.43	282.43	281.97	282.05	45179.0
2019-05-23 19:00:00	SPY	ETF	282.09	282.21	282.09	282.16	6559.0
2019-05-23 19:30:00	SPY	ETF	282.14	282.43	282.03	282.3	35994.0
2019-05-23 04:00:00	QQQ	ETF	179.69	179.69	179.08	179.18	28124.0
2019-05-23 04:30:00	QQQ	ETF	179.14	179.14	178.9	179.08	14900.0
2019-05-23 05:00:00	QQQ	ETF	179.05	179.2	178.78	178.8	27414.0
2019-05-23 05:30:00	QQQ	ETF	178.75	178.81	178.53	178.53	60485.0
2019-05-23 06:00:00	QQQ	ETF	178.55	178.67	178.33	178.67	37290.0
2019-05-23 06:30:00	QQQ	ETF	178.61	178.92	178.61	178.62	41917.0
2019-05-23 07:00:00	QQQ	ETF	178.69	179.07	178.69	179.03	45370.0
2019-05-23 07:30:00	QQQ	ETF	178.97	179.14	178.83	179.0	145704.0
2019-05-23 08:00:00	QQQ	ETF	179.04	181.02	178.68	178.86	190961.0
2019-05-23 08:30:00	QQQ	ETF	178.89	179.28	178.88	179.03	156920.0
2019-05-23 09:00:00	QQQ	ETF	179.04	179.08	178.72	179.0	222706.0
2019-05-23 09:30:00	QQQ	ETF	179.02	179.023	178.105	178.45	5345423.0
2019-05-23 10:00:00	QQQ	ETF	178.445	178.82	177.95	178.5	3535632.0
2019-05-23 10:30:00	QQQ	ETF	178.49	178.99	178.4	178.7175	2052950.0
2019-05-23 11:00:00	QQQ	ETF	178.7149	178.76	178.1	178.475	2069572.0
2019-05-23 11:30:00	QQQ	ETF	178.48	178.64	177.7	177.74	2342585.0
2019-05-23 12:00:00	QQQ	ETF	177.74	178.06	177.31	177.635	2345126.0
2019-05-23 12:30:00	QQQ	ETF	177.63	177.74	177.19	177.27	2258575.0

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

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