PREVIEW / etf_30min / 2019-05-15

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-05-15.parquet
  size:    494 KB
  rows:    17,136

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-15 04:00:00	SPY	ETF	283.41	283.6	283.21	283.6	5228.0
2019-05-15 04:30:00	SPY	ETF	283.62	283.75	283.62	283.62	1100.0
2019-05-15 05:00:00	SPY	ETF	283.7	283.84	283.7	283.78	4572.0
2019-05-15 05:30:00	SPY	ETF	283.5	283.5	282.87	282.95	28622.0
2019-05-15 06:00:00	SPY	ETF	282.92	283.13	282.62	282.62	7078.0
2019-05-15 06:30:00	SPY	ETF	282.63	283.05	282.57	283.05	46215.0
2019-05-15 07:00:00	SPY	ETF	283.0	283.2	283.0	283.1	47256.0
2019-05-15 07:30:00	SPY	ETF	283.05	283.05	282.65	282.68	158909.0
2019-05-15 08:00:00	SPY	ETF	283.0799	284.49	282.29	282.43	433898.0
2019-05-15 08:30:00	SPY	ETF	282.38	282.49	281.54	281.85	643864.0
2019-05-15 09:00:00	SPY	ETF	281.83	282.04	281.3	281.6	730617.0
2019-05-15 09:30:00	SPY	ETF	281.59	282.48	281.36	282.27	7762844.0
2019-05-15 10:00:00	SPY	ETF	282.27	284.08	281.77	283.95	10189828.0
2019-05-15 10:30:00	SPY	ETF	283.96	284.51	283.75	284.2485	4893107.0
2019-05-15 11:00:00	SPY	ETF	284.25	284.97	283.84	284.945	4106871.0
2019-05-15 11:30:00	SPY	ETF	284.94	285.28	284.7	285.16	4243604.0
2019-05-15 12:00:00	SPY	ETF	285.16	285.56	284.81	284.97	3129983.0
2019-05-15 12:30:00	SPY	ETF	284.97	285.3	284.7	284.89	2769152.0
2019-05-15 13:00:00	SPY	ETF	284.89	285.13	284.7101	284.8783	1984579.0
2019-05-15 13:30:00	SPY	ETF	284.88	285.5	284.88	285.44	2110392.0
2019-05-15 14:00:00	SPY	ETF	285.43	285.68	285.39	285.5465	2445841.0
2019-05-15 14:30:00	SPY	ETF	285.54	285.76	285.26	285.3	3098951.0
2019-05-15 15:00:00	SPY	ETF	285.29	285.74	285.15	285.66	3987780.0
2019-05-15 15:30:00	SPY	ETF	285.66	285.77	284.97	285.06	11070496.0
2019-05-15 16:00:00	SPY	ETF	285.06	285.33	282.0005	285.26	7732183.0
2019-05-15 16:30:00	SPY	ETF	285.26	285.46	285.06	285.24	629544.0
2019-05-15 17:00:00	SPY	ETF	285.27	285.29	285.06	285.21	66312.0
2019-05-15 17:30:00	SPY	ETF	285.21	285.25	285.06	285.15	106915.0
2019-05-15 18:00:00	SPY	ETF	285.17	285.18	284.95	285.06	59161.0
2019-05-15 18:30:00	SPY	ETF	285.05	285.1	284.9	285.06	90649.0
2019-05-15 19:00:00	SPY	ETF	285.06	285.06	284.89	284.94	16641.0
2019-05-15 19:30:00	SPY	ETF	284.98	285.06	284.93	284.97	25708.0
2019-05-15 04:00:00	QQQ	ETF	180.72	180.8	180.5	180.79	4308.0
2019-05-15 04:30:00	QQQ	ETF	180.84	180.96	180.8	180.94	58360.0
2019-05-15 05:00:00	QQQ	ETF	180.75	181.07	180.75	181.04	9450.0
2019-05-15 05:30:00	QQQ	ETF	180.97	180.97	180.33	180.36	13952.0
2019-05-15 06:00:00	QQQ	ETF	180.37	180.56	180.09	180.13	25818.0
2019-05-15 06:30:00	QQQ	ETF	180.15	180.35	180.05	180.28	122683.0
2019-05-15 07:00:00	QQQ	ETF	180.34	180.52	180.34	180.47	56479.0
2019-05-15 07:30:00	QQQ	ETF	180.4	180.4	180.05	180.09	79735.0
2019-05-15 08:00:00	QQQ	ETF	180.43	181.36	179.72	179.85	277055.0
2019-05-15 08:30:00	QQQ	ETF	179.79	179.84	179.23	179.49	310453.0
2019-05-15 09:00:00	QQQ	ETF	179.48	179.65	179.06	179.39	475787.0
2019-05-15 09:30:00	QQQ	ETF	179.38	180.48	179.31	180.4	4829698.0
2019-05-15 10:00:00	QQQ	ETF	180.39	182.05	180.35	181.9201	5690671.0
2019-05-15 10:30:00	QQQ	ETF	181.92	182.37	181.74	182.13	2616737.0
2019-05-15 11:00:00	QQQ	ETF	182.13	182.87	181.795	182.85	2443631.0
2019-05-15 11:30:00	QQQ	ETF	182.845	182.955	182.52	182.74	2328334.0
2019-05-15 12:00:00	QQQ	ETF	182.75	183.1368	182.52	182.65	2610412.0
2019-05-15 12:30:00	QQQ	ETF	182.6515	182.84	182.32	182.44	1295745.0

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

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