PREVIEW / etf_30min / 2020-01-30

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-01-30.parquet
  size:    563 KB
  rows:    19,873

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-01-30 04:00:00	SPY	ETF	324.5	325.32	324.3	325.06	41299.0
2020-01-30 04:30:00	SPY	ETF	324.97	325.0	324.65	324.78	12939.0
2020-01-30 05:00:00	SPY	ETF	324.69	324.76	324.5	324.61	6143.0
2020-01-30 05:30:00	SPY	ETF	324.5	324.75	324.43	324.55	9544.0
2020-01-30 06:00:00	SPY	ETF	324.49	324.49	323.8	324.12	28399.0
2020-01-30 06:30:00	SPY	ETF	324.12	324.49	324.08	324.38	118630.0
2020-01-30 07:00:00	SPY	ETF	324.43	324.55	324.17	324.21	243270.0
2020-01-30 07:30:00	SPY	ETF	324.15	324.36	323.96	324.05	291680.0
2020-01-30 08:00:00	SPY	ETF	324.45	326.62	323.48	324.5	438414.0
2020-01-30 08:30:00	SPY	ETF	324.56	325.14	324.3	324.61	543024.0
2020-01-30 09:00:00	SPY	ETF	324.6	325.03	324.33	324.35	405163.0
2020-01-30 09:30:00	SPY	ETF	324.36	325.89	324.3	325.19	6749072.0
2020-01-30 10:00:00	SPY	ETF	325.19	325.87	324.96	325.2377	3236639.0
2020-01-30 10:30:00	SPY	ETF	325.24	326.6278	323.54	323.72	5492052.0
2020-01-30 11:00:00	SPY	ETF	323.73	325.0925	323.645	324.935	4194674.0
2020-01-30 11:30:00	SPY	ETF	324.94	325.6907	324.75	325.17	3595102.0
2020-01-30 12:00:00	SPY	ETF	325.18	325.35	324.54	324.55	2218595.0
2020-01-30 12:30:00	SPY	ETF	324.54	324.72	323.86	324.27	6244160.0
2020-01-30 13:00:00	SPY	ETF	324.28	324.57	324.04	324.425	2346287.0
2020-01-30 13:30:00	SPY	ETF	324.42	324.72	324.26	324.54	2148711.0
2020-01-30 14:00:00	SPY	ETF	324.55	325.3093	324.45	325.135	3320343.0
2020-01-30 14:30:00	SPY	ETF	325.14	326.17	324.2	325.88	9644601.0
2020-01-30 15:00:00	SPY	ETF	325.89	326.67	325.74	326.41	7098342.0
2020-01-30 15:30:00	SPY	ETF	326.4	327.91	326.34	327.66	11501432.0
2020-01-30 16:00:00	SPY	ETF	327.65	328.6	326.6278	328.37	3110783.0
2020-01-30 16:30:00	SPY	ETF	328.4	328.9	327.68	328.8	396897.0
2020-01-30 17:00:00	SPY	ETF	328.77	328.77	328.32	328.49	132915.0
2020-01-30 17:30:00	SPY	ETF	328.45	328.5	328.16	328.49	140887.0
2020-01-30 18:00:00	SPY	ETF	328.5	328.61	328.25	328.4	161843.0
2020-01-30 18:30:00	SPY	ETF	328.42	328.54	328.3	328.3	33225.0
2020-01-30 19:00:00	SPY	ETF	328.36	328.45	327.85	327.86	49491.0
2020-01-30 19:30:00	SPY	ETF	327.98	328.6	327.98	328.6	55798.0
2020-01-30 04:00:00	QQQ	ETF	220.07	220.78	219.94	220.57	56794.0
2020-01-30 04:30:00	QQQ	ETF	220.58	220.58	220.33	220.39	8600.0
2020-01-30 05:00:00	QQQ	ETF	220.32	220.39	220.13	220.14	11414.0
2020-01-30 05:30:00	QQQ	ETF	220.06	220.32	220.04	220.13	20769.0
2020-01-30 06:00:00	QQQ	ETF	220.06	220.17	219.56	219.75	46076.0
2020-01-30 06:30:00	QQQ	ETF	219.86	220.05	219.79	219.92	42779.0
2020-01-30 07:00:00	QQQ	ETF	220.07	220.29	219.88	220.15	143679.0
2020-01-30 07:30:00	QQQ	ETF	219.98	220.26	219.93	219.99	77671.0
2020-01-30 08:00:00	QQQ	ETF	220.04	221.81	219.32	220.34	264530.0
2020-01-30 08:30:00	QQQ	ETF	220.32	220.88	220.2	220.54	203180.0
2020-01-30 09:00:00	QQQ	ETF	220.53	220.92	220.35	220.36	169753.0
2020-01-30 09:30:00	QQQ	ETF	220.37	221.89	220.19	221.14	3640322.0
2020-01-30 10:00:00	QQQ	ETF	221.14	221.74	220.8598	221.115	2456621.0
2020-01-30 10:30:00	QQQ	ETF	221.09	221.7	219.7	219.75	2940226.0
2020-01-30 11:00:00	QQQ	ETF	219.75	220.77	219.6891	220.69	1648225.0
2020-01-30 11:30:00	QQQ	ETF	220.695	221.33	220.57	220.89	1470684.0
2020-01-30 12:00:00	QQQ	ETF	220.89	221.05	220.4402	220.45	742716.0
2020-01-30 12:30:00	QQQ	ETF	220.44	220.58	219.86	220.17	1946327.0

> showing 50 of 19,873 rows — these rows as CSV

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