PREVIEW / etf_30min / 2009-10-06

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-10-06.parquet
  size:    235 KB
  rows:    7,838

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
2009-10-06 04:00:00	SPY	ETF	104.3	104.47	104.3	104.47	600.0
2009-10-06 04:30:00	SPY	ETF	104.49	104.53	104.49	104.53	700.0
2009-10-06 05:00:00	SPY	ETF	104.53	105.13	104.53	105.07	23349.0
2009-10-06 05:30:00	SPY	ETF	105.03	105.03	104.92	104.97	700.0
2009-10-06 06:00:00	SPY	ETF	104.86	105.04	104.86	104.99	23400.0
2009-10-06 06:30:00	SPY	ETF	105.0	105.15	105.0	105.1	14310.0
2009-10-06 07:00:00	SPY	ETF	105.08	105.1	105.0	105.08	743302.0
2009-10-06 07:30:00	SPY	ETF	105.08	105.23	105.06	105.12	409889.0
2009-10-06 08:00:00	SPY	ETF	105.1	105.13	104.89	104.97	1544232.0
2009-10-06 08:30:00	SPY	ETF	104.98	105.04	104.02	104.91	933132.0
2009-10-06 09:00:00	SPY	ETF	104.91	104.99	104.76	104.77	2035063.0
2009-10-06 09:30:00	SPY	ETF	104.77	105.59	104.71	105.46	26559393.0
2009-10-06 10:00:00	SPY	ETF	105.47	105.66	105.39	105.39	14310292.0
2009-10-06 10:30:00	SPY	ETF	105.39	105.75	105.37	105.6983	10057903.0
2009-10-06 11:00:00	SPY	ETF	105.69	106.11	105.64	105.9	13802418.0
2009-10-06 11:30:00	SPY	ETF	105.89	105.93	105.68	105.771	9562407.0
2009-10-06 12:00:00	SPY	ETF	105.77	105.89	105.74	105.8196	5827964.0
2009-10-06 12:30:00	SPY	ETF	105.81	105.95	105.55	105.59	8139671.0
2009-10-06 13:00:00	SPY	ETF	105.59	105.64	105.4	105.58	10161147.0
2009-10-06 13:30:00	SPY	ETF	105.58	105.63	105.1	105.26	12604468.0
2009-10-06 14:00:00	SPY	ETF	105.27	105.28	104.73	104.81	18947261.0
2009-10-06 14:30:00	SPY	ETF	104.81	105.24	104.73	105.16	17313016.0
2009-10-06 15:00:00	SPY	ETF	105.1651	105.66	105.09	105.58	18022188.0
2009-10-06 15:30:00	SPY	ETF	105.58	105.7	105.26	105.52	24304037.0
2009-10-06 16:00:00	SPY	ETF	105.5	105.998	104.78	105.33	5957522.0
2009-10-06 16:30:00	SPY	ETF	105.32	105.4	104.0774	105.38	798746.0
2009-10-06 17:00:00	SPY	ETF	105.4	105.4	105.33	105.33	103298.0
2009-10-06 17:30:00	SPY	ETF	105.33	105.39	105.33	105.36	9450.0
2009-10-06 18:00:00	SPY	ETF	105.37	105.38	105.34	105.38	28563.0
2009-10-06 18:30:00	SPY	ETF	105.38	105.4	105.37	105.39	8000.0
2009-10-06 19:00:00	SPY	ETF	105.4	105.43	105.4	105.42	7832.0
2009-10-06 19:30:00	SPY	ETF	105.42	105.45	105.42	105.45	16338.0
2009-10-06 05:00:00	QQQ	ETF	41.45	41.58	41.45	41.57	8200.0
2009-10-06 06:00:00	QQQ	ETF	41.5	41.56	41.5	41.52	3800.0
2009-10-06 06:30:00	QQQ	ETF	41.56	41.57	41.55	41.56	2683.0
2009-10-06 07:00:00	QQQ	ETF	41.55	41.58	41.5	41.54	574000.0
2009-10-06 07:30:00	QQQ	ETF	41.55	41.6	41.54	41.56	121197.0
2009-10-06 08:00:00	QQQ	ETF	41.55	41.57	41.48	41.49	868799.0
2009-10-06 08:30:00	QQQ	ETF	41.5	41.52	41.45	41.47	478133.0
2009-10-06 09:00:00	QQQ	ETF	41.47	41.5	41.41	41.43	1912836.0
2009-10-06 09:30:00	QQQ	ETF	41.43	41.85	41.42	41.8	17465013.0
2009-10-06 10:00:00	QQQ	ETF	41.81	42.02	41.8	41.88	10661088.0
2009-10-06 10:30:00	QQQ	ETF	41.88	42.01	41.82	41.95	6918014.0
2009-10-06 11:00:00	QQQ	ETF	41.95	42.14	41.9	42.03	8057781.0
2009-10-06 11:30:00	QQQ	ETF	42.04	42.07	41.94	41.98	5290578.0
2009-10-06 12:00:00	QQQ	ETF	41.97	42.03	41.95	42.0	2534079.0
2009-10-06 12:30:00	QQQ	ETF	42.0001	42.085	41.95	41.96	3193406.0
2009-10-06 13:00:00	QQQ	ETF	41.9594	42.0	41.87	41.9799	4628078.0
2009-10-06 13:30:00	QQQ	ETF	41.98	41.98	41.76	41.81	7748524.0
2009-10-06 14:00:00	QQQ	ETF	41.81	41.82	41.54	41.5674	11974383.0

> showing 50 of 7,838 rows — these rows as CSV

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