PREVIEW / etf_30min / 2009-01-30

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-01-30.parquet
  size:    203 KB
  rows:    6,675

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-01-30 04:00:00	SPY	ETF	85.2	85.2	85.2	85.2	100.0
2009-01-30 04:30:00	SPY	ETF	85.01	85.01	85.01	85.01	100.0
2009-01-30 05:00:00	SPY	ETF	84.7	84.83	84.7	84.83	300.0
2009-01-30 06:00:00	SPY	ETF	85.11	85.11	84.86	84.86	900.0
2009-01-30 06:30:00	SPY	ETF	84.86	84.86	84.54	84.6	92400.0
2009-01-30 07:00:00	SPY	ETF	84.49	84.54	84.26	84.43	203589.0
2009-01-30 07:30:00	SPY	ETF	84.41	84.44	83.75	83.81	899445.0
2009-01-30 08:00:00	SPY	ETF	83.82	84.37	83.82	84.13	1406096.0
2009-01-30 08:30:00	SPY	ETF	84.14	85.1	84.14	84.91	10088663.0
2009-01-30 09:00:00	SPY	ETF	84.9	84.99	84.5	84.98	3279990.0
2009-01-30 09:30:00	SPY	ETF	84.98	85.4	84.23	84.23	38447738.0
2009-01-30 10:00:00	SPY	ETF	84.23	84.6	83.56	83.59	30347136.0
2009-01-30 10:30:00	SPY	ETF	83.59	83.7	83.28	83.59	26101858.0
2009-01-30 11:00:00	SPY	ETF	83.58	83.86	82.95	83.09	23879354.0
2009-01-30 11:30:00	SPY	ETF	83.08	83.51	83.05	83.4	13937555.0
2009-01-30 12:00:00	SPY	ETF	83.4	83.71	83.16	83.62	13611148.0
2009-01-30 12:30:00	SPY	ETF	83.62	83.87	83.44	83.8	10851387.0
2009-01-30 13:00:00	SPY	ETF	83.8	84.22	83.25	83.49	23562997.0
2009-01-30 13:30:00	SPY	ETF	83.49	83.51	82.77	83.27	30503675.0
2009-01-30 14:00:00	SPY	ETF	83.27	83.64	83.07	83.47	20961165.0
2009-01-30 14:30:00	SPY	ETF	83.47	83.69	82.93	83.12	14969357.0
2009-01-30 15:00:00	SPY	ETF	83.12	83.38	82.5	82.52	31861861.0
2009-01-30 15:30:00	SPY	ETF	82.53	82.93	82.21	82.69	53671431.0
2009-01-30 16:00:00	SPY	ETF	82.76	83.4649	82.65	82.99	21371972.0
2009-01-30 16:30:00	SPY	ETF	82.99	84.5976	82.69	83.04	9201359.0
2009-01-30 17:00:00	SPY	ETF	83.02	83.1	82.89	83.06	716668.0
2009-01-30 17:30:00	SPY	ETF	83.06	83.07	82.92	82.97	73944.0
2009-01-30 18:00:00	SPY	ETF	82.97	83.34	82.95	83.13	86795.0
2009-01-30 18:30:00	SPY	ETF	83.12	83.24	83.08	83.17	21376.0
2009-01-30 19:00:00	SPY	ETF	83.09	83.15	83.02	83.12	24790.0
2009-01-30 19:30:00	SPY	ETF	83.12	83.12	83.03	83.03	6649.0
2009-01-30 04:00:00	QQQ	ETF	29.85	29.88	29.84	29.84	6800.0
2009-01-30 04:30:00	QQQ	ETF	29.89	29.89	29.89	29.89	100.0
2009-01-30 05:30:00	QQQ	ETF	29.84	29.84	29.84	29.84	500.0
2009-01-30 06:30:00	QQQ	ETF	29.75	29.75	29.66	29.66	5700.0
2009-01-30 07:00:00	QQQ	ETF	29.63	29.63	29.57	29.6	40914.0
2009-01-30 07:30:00	QQQ	ETF	29.6	29.6	29.43	29.44	94192.0
2009-01-30 08:00:00	QQQ	ETF	29.46	29.55	29.44	29.49	231880.0
2009-01-30 08:30:00	QQQ	ETF	29.5	29.88	29.5	29.82	1547661.0
2009-01-30 09:00:00	QQQ	ETF	29.82	29.84	29.73	29.82	628799.0
2009-01-30 09:30:00	QQQ	ETF	29.82	29.93	29.53	29.53	14842721.0
2009-01-30 10:00:00	QQQ	ETF	29.52	29.57	29.28	29.29	9382468.0
2009-01-30 10:30:00	QQQ	ETF	29.28	29.35	29.19	29.32	9223799.0
2009-01-30 11:00:00	QQQ	ETF	29.32	29.42	29.07	29.12	10264871.0
2009-01-30 11:30:00	QQQ	ETF	29.12	29.24	29.09	29.18	6356892.0
2009-01-30 12:00:00	QQQ	ETF	29.18	29.34	29.11	29.31	7018220.0
2009-01-30 12:30:00	QQQ	ETF	29.32	29.35	29.24	29.34	3705634.0
2009-01-30 13:00:00	QQQ	ETF	29.34	29.53	29.28	29.31	8343738.0
2009-01-30 13:30:00	QQQ	ETF	29.31	29.34	29.13	29.3001	10397524.0
2009-01-30 14:00:00	QQQ	ETF	29.3	29.44	29.25	29.37	7647382.0

> showing 50 of 6,675 rows — these rows as CSV

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