PREVIEW / etf_30min / 2020-03-16

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-03-16.parquet
  size:    647 KB
  rows:    23,949

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-03-16 04:00:00	SPY	ETF	253.2	262.75	248.51	249.0	335195.0
2020-03-16 04:30:00	SPY	ETF	248.86	248.96	244.0	246.23	262157.0
2020-03-16 05:00:00	SPY	ETF	246.2	246.2	244.3	244.47	281479.0
2020-03-16 05:30:00	SPY	ETF	244.45	246.29	244.22	245.27	172059.0
2020-03-16 06:00:00	SPY	ETF	245.2	245.52	243.0	243.43	210785.0
2020-03-16 06:30:00	SPY	ETF	243.43	243.93	242.8	243.35	255431.0
2020-03-16 07:00:00	SPY	ETF	243.35	244.47	243.1	243.51	983614.0
2020-03-16 07:30:00	SPY	ETF	243.56	244.05	241.94	243.1	1302320.0
2020-03-16 08:00:00	SPY	ETF	243.1	260.0158	240.88	243.07	2392905.0
2020-03-16 08:30:00	SPY	ETF	243.02	243.07	239.35	239.75	1767095.0
2020-03-16 09:00:00	SPY	ETF	239.85	242.5	238.9	240.94	2899481.0
2020-03-16 09:30:00	SPY	ETF	241.18	247.79	237.36	245.57	19545141.0
2020-03-16 10:00:00	SPY	ETF	245.59	247.44	242.52	245.89	23240437.0
2020-03-16 10:30:00	SPY	ETF	245.89	252.96	245.8101	250.77	22838419.0
2020-03-16 11:00:00	SPY	ETF	250.77	256.9	250.21	256.03	19383056.0
2020-03-16 11:30:00	SPY	ETF	255.99	256.5	251.53	254.13	14802343.0
2020-03-16 12:00:00	SPY	ETF	254.12	254.77	250.0	251.38	11104217.0
2020-03-16 12:30:00	SPY	ETF	251.39	253.01	247.84	248.97	13787641.0
2020-03-16 13:00:00	SPY	ETF	248.97	251.64	248.31	249.03	10419330.0
2020-03-16 13:30:00	SPY	ETF	249.04	249.04	246.16	247.205	12616206.0
2020-03-16 14:00:00	SPY	ETF	247.2	250.74	244.66	246.6	13258100.0
2020-03-16 14:30:00	SPY	ETF	246.605	251.04	240.78	249.105	19560568.0
2020-03-16 15:00:00	SPY	ETF	249.11	250.85	245.65	246.025	19129985.0
2020-03-16 15:30:00	SPY	ETF	246.01	246.3	238.8	239.41	62099046.0
2020-03-16 16:00:00	SPY	ETF	239.5	244.8	239.21	240.73	13407949.0
2020-03-16 16:30:00	SPY	ETF	240.77	248.7395	239.85	241.61	4012687.0
2020-03-16 17:00:00	SPY	ETF	241.79	242.0	240.0	240.97	853141.0
2020-03-16 17:30:00	SPY	ETF	240.96	241.78	240.51	241.55	257270.0
2020-03-16 18:00:00	SPY	ETF	241.55	245.63	240.88	242.84	794493.0
2020-03-16 18:30:00	SPY	ETF	242.63	244.87	242.12	243.2	731997.0
2020-03-16 19:00:00	SPY	ETF	243.2	245.27	243.2	244.96	302047.0
2020-03-16 19:30:00	SPY	ETF	244.81	245.8	243.83	244.9	159316.0
2020-03-16 04:00:00	QQQ	ETF	181.1	183.0	177.5	178.85	82161.0
2020-03-16 04:30:00	QQQ	ETF	178.78	178.78	176.5	176.89	33296.0
2020-03-16 05:00:00	QQQ	ETF	176.7	177.0	175.07	176.76	69425.0
2020-03-16 05:30:00	QQQ	ETF	176.7	176.7	175.77	175.77	73963.0
2020-03-16 06:00:00	QQQ	ETF	175.84	176.0	175.05	175.65	55313.0
2020-03-16 06:30:00	QQQ	ETF	175.79	176.05	175.02	176.05	60161.0
2020-03-16 07:00:00	QQQ	ETF	175.31	177.07	175.11	175.64	269953.0
2020-03-16 07:30:00	QQQ	ETF	175.82	176.19	175.11	175.5	274708.0
2020-03-16 08:00:00	QQQ	ETF	175.6	185.6801	175.1	175.8	381456.0
2020-03-16 08:30:00	QQQ	ETF	175.85	175.89	173.8	174.06	432109.0
2020-03-16 09:00:00	QQQ	ETF	174.06	175.13	173.87	173.87	502458.0
2020-03-16 09:30:00	QQQ	ETF	174.15	178.5	171.25	176.83	5591614.0
2020-03-16 10:00:00	QQQ	ETF	176.79	178.63	173.6354	177.33	5946198.0
2020-03-16 10:30:00	QQQ	ETF	177.33	181.88	177.28	180.75	6862425.0
2020-03-16 11:00:00	QQQ	ETF	180.73	184.68	180.3	184.231	5402829.0
2020-03-16 11:30:00	QQQ	ETF	184.18	184.68	181.575	183.47	4514740.0
2020-03-16 12:00:00	QQQ	ETF	183.43	183.83	180.65	181.14	3100154.0
2020-03-16 12:30:00	QQQ	ETF	181.13	182.42	178.94	179.65	3105965.0

> showing 50 of 23,949 rows — these rows as CSV

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