PREVIEW / etf_30min / 2020-05-13

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-05-13.parquet
  size:    571 KB
  rows:    21,262

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
2020-05-13 04:00:00	SPY	ETF	285.68	286.36	285.24	286.2	64703.0
2020-05-13 04:30:00	SPY	ETF	286.26	286.59	285.46	285.55	59980.0
2020-05-13 05:00:00	SPY	ETF	285.39	286.41	285.26	285.99	46025.0
2020-05-13 05:30:00	SPY	ETF	285.96	287.24	285.82	286.98	89996.0
2020-05-13 06:00:00	SPY	ETF	286.9	287.66	286.89	287.43	141280.0
2020-05-13 06:30:00	SPY	ETF	287.38	287.42	286.92	287.21	156776.0
2020-05-13 07:00:00	SPY	ETF	287.3	287.34	286.85	287.21	245899.0
2020-05-13 07:30:00	SPY	ETF	287.25	287.94	287.13	287.64	364172.0
2020-05-13 08:00:00	SPY	ETF	287.62	287.92	285.0	287.57	341930.0
2020-05-13 08:30:00	SPY	ETF	287.47	287.71	286.75	286.86	492304.0
2020-05-13 09:00:00	SPY	ETF	286.81	286.81	284.82	286.05	2256012.0
2020-05-13 09:30:00	SPY	ETF	286.06	286.38	283.64	284.85	12678291.0
2020-05-13 10:00:00	SPY	ETF	284.84	286.48	284.73	286.32	8383828.0
2020-05-13 10:30:00	SPY	ETF	286.33	287.19	284.57	284.75	7561479.0
2020-05-13 11:00:00	SPY	ETF	284.76	285.39	283.25	283.99	7886275.0
2020-05-13 11:30:00	SPY	ETF	283.98	284.27	281.18	281.87	11661893.0
2020-05-13 12:00:00	SPY	ETF	281.87	282.27	279.61	281.1386	15914864.0
2020-05-13 12:30:00	SPY	ETF	281.15	281.94	280.73	281.725	7751895.0
2020-05-13 13:00:00	SPY	ETF	281.7162	282.07	280.43	281.4224	5854134.0
2020-05-13 13:30:00	SPY	ETF	281.41	281.69	280.62	280.78	3654635.0
2020-05-13 14:00:00	SPY	ETF	280.79	281.83	280.155	280.7105	5334087.0
2020-05-13 14:30:00	SPY	ETF	280.69	280.91	279.67	279.6728	5707875.0
2020-05-13 15:00:00	SPY	ETF	279.67	281.25	278.965	279.8216	11791452.0
2020-05-13 15:30:00	SPY	ETF	279.82	282.09	279.48	281.67	21285413.0
2020-05-13 16:00:00	SPY	ETF	281.67	282.31	281.28	281.75	8225439.0
2020-05-13 16:30:00	SPY	ETF	281.76	282.25	281.6	282.2	2332027.0
2020-05-13 17:00:00	SPY	ETF	281.68	282.25	281.68	282.08	1387458.0
2020-05-13 17:30:00	SPY	ETF	282.08	282.32	281.6	282.3	1623557.0
2020-05-13 18:00:00	SPY	ETF	282.33	282.75	281.95	282.0	204411.0
2020-05-13 18:30:00	SPY	ETF	282.04	282.49	281.91	282.44	103643.0
2020-05-13 19:00:00	SPY	ETF	282.48	282.7	282.22	282.6	85120.0
2020-05-13 19:30:00	SPY	ETF	282.61	282.81	281.9	282.02	287197.0
2020-05-13 04:00:00	QQQ	ETF	222.02	222.58	221.62	222.49	30012.0
2020-05-13 04:30:00	QQQ	ETF	222.52	222.76	221.97	221.97	29940.0
2020-05-13 05:00:00	QQQ	ETF	221.93	222.6	221.84	222.4	25035.0
2020-05-13 05:30:00	QQQ	ETF	222.26	223.28	222.2	222.99	39789.0
2020-05-13 06:00:00	QQQ	ETF	222.94	223.53	222.94	223.36	32031.0
2020-05-13 06:30:00	QQQ	ETF	223.36	223.36	222.98	223.25	32090.0
2020-05-13 07:00:00	QQQ	ETF	223.35	223.35	222.96	223.25	97744.0
2020-05-13 07:30:00	QQQ	ETF	223.31	223.8	223.14	223.64	96062.0
2020-05-13 08:00:00	QQQ	ETF	223.6	223.77	221.31	223.63	153843.0
2020-05-13 08:30:00	QQQ	ETF	223.6	223.71	223.0701	223.13	172705.0
2020-05-13 09:00:00	QQQ	ETF	223.08	223.08	221.79	222.66	533579.0
2020-05-13 09:30:00	QQQ	ETF	222.65	223.11	220.7	222.44	6384133.0
2020-05-13 10:00:00	QQQ	ETF	222.42	224.13	222.33	224.0	4261644.0
2020-05-13 10:30:00	QQQ	ETF	224.03	224.61	222.32	222.46	3784387.0
2020-05-13 11:00:00	QQQ	ETF	222.48	223.17	221.09	221.66	4120871.0
2020-05-13 11:30:00	QQQ	ETF	221.67	221.9	219.12	219.56	5423035.0
2020-05-13 12:00:00	QQQ	ETF	219.57	219.8	216.89	218.56	6515081.0
2020-05-13 12:30:00	QQQ	ETF	218.5715	219.5299	217.96	219.15	3604361.0

> showing 50 of 21,262 rows — these rows as CSV

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