PREVIEW / etf_30min / 2020-04-06

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-04-06.parquet
  size:    584 KB
  rows:    21,665

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-04-06 04:00:00	SPY	ETF	258.24	258.7	257.01	257.7	168661.0
2020-04-06 04:30:00	SPY	ETF	257.68	258.2	257.01	258.2	76701.0
2020-04-06 05:00:00	SPY	ETF	258.18	258.37	257.53	258.25	193800.0
2020-04-06 05:30:00	SPY	ETF	258.27	258.69	257.94	258.35	76096.0
2020-04-06 06:00:00	SPY	ETF	258.34	258.49	257.4	257.45	418123.0
2020-04-06 06:30:00	SPY	ETF	257.34	258.13	257.3	257.84	105469.0
2020-04-06 07:00:00	SPY	ETF	257.97	257.99	257.35	257.8	425658.0
2020-04-06 07:30:00	SPY	ETF	257.75	258.11	257.46	257.71	335041.0
2020-04-06 08:00:00	SPY	ETF	257.69	259.0	256.59	257.02	760229.0
2020-04-06 08:30:00	SPY	ETF	257.05	258.08	256.93	257.9	857811.0
2020-04-06 09:00:00	SPY	ETF	257.89	258.32	257.49	257.89	1026275.0
2020-04-06 09:30:00	SPY	ETF	257.84	259.99	256.725	259.7979	16094612.0
2020-04-06 10:00:00	SPY	ETF	259.79	260.81	259.47	259.7	11010425.0
2020-04-06 10:30:00	SPY	ETF	259.7	260.19	258.72	259.33	12625685.0
2020-04-06 11:00:00	SPY	ETF	259.33	260.3	258.91	260.25	7198903.0
2020-04-06 11:30:00	SPY	ETF	260.24	261.24	259.77	260.85	9229223.0
2020-04-06 12:00:00	SPY	ETF	260.88	262.5	260.67	262.13	11642270.0
2020-04-06 12:30:00	SPY	ETF	262.1389	262.41	261.54	262.38	7250905.0
2020-04-06 13:00:00	SPY	ETF	262.385	262.5	261.68	262.035	7431886.0
2020-04-06 13:30:00	SPY	ETF	262.0379	262.955	261.58	262.81	7282253.0
2020-04-06 14:00:00	SPY	ETF	262.8	262.83	261.28	261.67	7899787.0
2020-04-06 14:30:00	SPY	ETF	261.66	262.59	261.4	262.43	6702622.0
2020-04-06 15:00:00	SPY	ETF	262.43	263.15	261.74	263.025	11861692.0
2020-04-06 15:30:00	SPY	ETF	263.027	267.0	262.65	264.96	41949820.0
2020-04-06 16:00:00	SPY	ETF	264.96	265.6109	262.6165	264.85	19241158.0
2020-04-06 16:30:00	SPY	ETF	264.87	265.1	264.65	264.96	1850749.0
2020-04-06 17:00:00	SPY	ETF	264.99	265.13	264.85	265.0	272411.0
2020-04-06 17:30:00	SPY	ETF	265.0	265.22	264.8	264.85	142513.0
2020-04-06 18:00:00	SPY	ETF	264.85	265.08	263.99	264.2	440578.0
2020-04-06 18:30:00	SPY	ETF	264.22	264.47	263.73	264.11	122656.0
2020-04-06 19:00:00	SPY	ETF	264.1	265.68	264.0	265.18	231429.0
2020-04-06 19:30:00	SPY	ETF	265.24	266.61	265.13	266.55	560464.0
2020-04-06 04:00:00	QQQ	ETF	191.01	191.31	190.32	190.83	122807.0
2020-04-06 04:30:00	QQQ	ETF	190.84	191.35	190.53	191.3	51640.0
2020-04-06 05:00:00	QQQ	ETF	191.34	191.36	190.74	191.25	31438.0
2020-04-06 05:30:00	QQQ	ETF	191.28	191.55	191.1	191.3	53574.0
2020-04-06 06:00:00	QQQ	ETF	191.25	191.5	190.8	190.83	48561.0
2020-04-06 06:30:00	QQQ	ETF	190.8	191.12	190.72	191.0	17122.0
2020-04-06 07:00:00	QQQ	ETF	191.06	191.06	190.28	190.6	192376.0
2020-04-06 07:30:00	QQQ	ETF	190.57	190.8	190.32	190.55	291936.0
2020-04-06 08:00:00	QQQ	ETF	190.55	191.71	189.92	190.25	327931.0
2020-04-06 08:30:00	QQQ	ETF	190.21	190.85	190.14	190.7	215813.0
2020-04-06 09:00:00	QQQ	ETF	190.7	190.83	190.33	190.34	570601.0
2020-04-06 09:30:00	QQQ	ETF	190.38	191.76	189.19	191.665	7263601.0
2020-04-06 10:00:00	QQQ	ETF	191.66	192.06	191.133	191.63	4198001.0
2020-04-06 10:30:00	QQQ	ETF	191.64	192.3	191.3	191.65	2944456.0
2020-04-06 11:00:00	QQQ	ETF	191.67	192.38	191.405	192.34	2875797.0
2020-04-06 11:30:00	QQQ	ETF	192.35	192.74	191.92	192.515	3054919.0
2020-04-06 12:00:00	QQQ	ETF	192.52	193.48	192.34	193.39	2688671.0
2020-04-06 12:30:00	QQQ	ETF	193.38	193.65	193.09	193.65	1949469.0

> showing 50 of 21,665 rows — these rows as CSV

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